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_flavor

A flavor is the instance model defining its characteristics in terms of resources.

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

Examples

List flavor of a cloud project

select
  id,
  name,
  type
from
  ovh_cloud_flavor
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'

List available linux flavors

select
  id,
  name,
  type
from
  ovh_cloud_flavor
where
  project_id = '27c5a6d3dfez87893jfd88fdsfmvnqb8'
  and os_type = 'linux'
  and available

Schema for ovh_cloud_flavor

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
available	boolean		Available in stock.
disk	bigint		Number of disk.
id	text	=	Flavor ID.
inbound_bandwidth	bigint		Max capacity of inbound traffic in Mbit/s.
name	text		Flavor name.
os_type	text		OS to install on.
outbound_bandwidth	bigint		Max capacity of outbound traffic in Mbit/s.
plan_codes_hourly	text		Plan code to order hourly instance
plan_codes_monthly	text		Plan code to order monthly instance
project_id	text	=	Project ID.
quota	bigint		Number instance you can spawn with your actual quota.
ram	bigint		Ram quantity (Gio).
region	text		Flavor region.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
type	text		Flavor type.
vcpus	bigint		Number of VCPUs.