turbot/equinix

steampipe plugin install equinixsteampipe plugin install equinix

Table: equinix_metal_plan

Information about Equinix Metal plans.

Examples

List all plans

select
*
from
equinix_metal_plan

Get CPU details for each plan

select
name,
cpu ->> 'count' as cpu_count,
cpu ->> 'type' as cpu_count
from
equinix_metal_plan,
jsonb_array_elements(specs -> 'cpus') as cpu

Plans by price

select
name,
pricing ->> 'hour' as hourly_cost
from
equinix_metal_plan
order by
hourly_cost

Plans available by metro

select
m.name as metro_name,
p.name as plan_name
from
equinix_metal_plan as p,
jsonb_array_elements_text(p.available_in_metros) as mid,
equinix_metal_metro as m
where
m.id = mid
order by
m.name,
p.name

.inspect equinix_metal_plan

Equinix Metal plans.

NameTypeDescription
available_injsonbFacility IDs where the plan is available.
available_in_metrosjsonbMetro IDs where the plan is available.
classtextClass of the plan.
deployment_typesjsonbDeployment types for the plan.
descriptiontextDescription of the plan.
hreftextURL of the plan.
idtextID of the plan.
legacybooleanTrue if this is a legacy plan.
linetextLine of the plan.
nametextName of the plan.
pricingjsonbPricing of the plan.
slugtextSlug of the plan.
specsjsonbSpecifications of the plan.