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_database

An hosted database.

The ovh_cloud_database table can be used to query information about databases and you must specify which cloud project in the where or join clause (where project_id=, join ovh_cloud_project on id=).

Examples

List database instances of a cloud project

select
  id,
  plan,
  status,
  description
from
  ovh_cloud_database
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'

List not ready database instances of a cloud project

select
  id,
  plan,
  status,
  description
from
  ovh_cloud_database
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and status != 'READY'

List PostgreSQL database of a cloud project

select
  id,
  plan,
  status,
  description
from
  ovh_cloud_database
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and engine = 'postgresql'

Schema for ovh_cloud_database

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
backup_time	text		Time on which backups start every day.
created_at	timestamp with time zone		Date of the creation of the cluster.
description	text		Description of the cluster.
engine	text		Name of the engine of the service.
flavor	text		The VM flavor used for this cluster.
id	text	=	Service ID.
maintenance_time	text		Time on which maintenances can start every day.
network_type	text		Type of network of the cluster.
node_number	text		Number of nodes in the cluster.
plan	text		Plan of the cluster.
project_id	text	=	Project ID.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		Current status of the cluster.
version	text		Version of the engine deployed on the cluster.