steampipe plugin install francois2metz/ovh

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
availablebooleanAvailable in stock.
diskbigintNumber of disk.
idtext=Flavor ID.
inbound_bandwidthbigintMax capacity of inbound traffic in Mbit/s.
nametextFlavor name.
os_typetextOS to install on.
outbound_bandwidthbigintMax capacity of outbound traffic in Mbit/s.
plan_codes_hourlytextPlan code to order hourly instance
plan_codes_monthlytextPlan code to order monthly instance
project_idtext=Project ID.
quotabigintNumber instance you can spawn with your actual quota.
rambigintRam quantity (Gio).
regiontextFlavor region.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
typetextFlavor type.
vcpusbigintNumber of VCPUs.