v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins

francois2metz/ovh

steampipe plugin install francois2metz/ovhsteampipe plugin install francois2metz/ovh

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.