steampipe plugin install francois2metz/ovhsteampipe plugin install francois2metz/ovh

ovh_bill ovh_bill_detail ovh_cloud_ai_app ovh_cloud_ai_job ovh_cloud_ai_notebook ovh_cloud_data_job ovh_cloud_database ovh_cloud_flavor ovh_cloud_image ovh_cloud_instance ovh_cloud_postgres ovh_cloud_project ovh_cloud_region ovh_cloud_ssh_key ovh_cloud_storage_s3 ovh_cloud_storage_swift ovh_cloud_volume ovh_cloud_volume_snapshot

Table: ovh_cloud_storage_s3

An S3 storage is an S3 object storage.

The ovh_cloud_storage_s3 table can be used to query information about storage containers and you must specify which cloud project AND region in the where clause (where project_id=xxxx and region=xxxx).

Examples

List S3 storage containers of a cloud project

select
  name,
  owner_id,
  objects_count,
  objects_size
from
  ovh_cloud_storage_s3
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and region = 'GRA'

List specific storage container

select
  name,
  owner_id,
  objects_count,
  objects_size
from
  ovh_cloud_storage_s3
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and region = 'GRA'
  and name = 'databucket'

Schema for ovh_cloud_storage_s3

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		The date and timestamp when the resource was created.
encryption_sse_algorithm	text		Encryption configuration.
name	text	=	Container name.
objects_count	bigint		Container total objects count.
objects_size	bigint		Container total objects size (bytes).
owner_id	bigint		Container owner userID.
project_id	text	=	Project ID.
region	text	=	Region of the container.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
virtual_host	text		Container virtual host.