ovh_billovh_bill_detailovh_cloud_ai_appovh_cloud_ai_jobovh_cloud_ai_notebookovh_cloud_data_jobovh_cloud_databaseovh_cloud_flavorovh_cloud_imageovh_cloud_instanceovh_cloud_postgresovh_cloud_projectovh_cloud_regionovh_cloud_ssh_keyovh_cloud_storage_s3ovh_cloud_storage_swiftovh_cloud_volumeovh_cloud_volume_snapshotovh_refundovh_refund_detail
Table: ovh_cloud_volume_snapshot
A volume snapshot a copy of the state of a storage volume at a particular point in time.
The ovh_cloud_volume_snapshot
table can be used to query information about volumes snapshots and you must specify which cloud project in the where or join clause (where project_id=
, join ovh_cloud_project on id=
).
Examples
List volumes snapshots of a cloud project
select id, namefrom ovh_cloud_volume_snapshotwhere project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
List available volumes snapshots of a cloud project
select id, namefrom ovh_cloud_volume_snapshotwhere project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8' and status = 'available'
Get one snapshot
select id, namefrom ovh_cloud_volume_snapshotwhere project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8' and id = 'd82f4336533f4d16ad92bf7b9f3d87e2'
Schema for ovh_cloud_volume_snapshot
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
creationDate | timestamp with time zone | Volume Snapshot creation date. | |
description | text | Volume Snapshot Description. | |
id | text | = | Volume Snapshot ID. |
name | text | Volume Snapshot Name. | |
planCode | text | Volume Snapshot Plan Code. | |
project_id | text | = | Project ID. |
region | text | Volume Snapshot Region. | |
size | bigint | Volume Snapshot size (in GB). | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
status | text | Volume Snapshot Status. (available, creating, deleting, error, error_deleting). | |
volumeId | text | Volume Snapshot Source ID. |