Table: equinix_metal_plan - Query Equinix Metal Plans using SQL

Equinix Metal Plans represent the various hardware and configuration options available to users on the Equinix Metal platform. These plans detail the specific configurations of the server, including the CPU, memory, storage, and network capabilities. It allows users to choose a plan that best fits their needs, based on their requirements and the workload they intend to run.

Table Usage Guide

The equinix_metal_plan table provides insights into the various plans available within the Equinix Metal platform. As a system administrator or DevOps engineer, explore plan-specific details through this table, including the plan's ID, slug, and description. Utilize it to uncover information about the various hardware and configuration options available, allowing you to choose a plan that best fits your needs and workload.

Examples

List all plans

Explore all available plans within your Equinix Metal environment to better understand the resources and services available to you. This can help in strategic planning and optimizing resource allocation.

select
  *
from
  equinix_metal_plan;

select
  *
from
  equinix_metal_plan;

Get CPU details for each plan

Explore the specific CPU details for each plan to better understand the resources allocated. This can assist in identifying the most suitable plan based on your CPU requirements.

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

select
  name,
  json_extract(cpu.value, '$.count') as cpu_count,
  json_extract(cpu.value, '$.type') as cpu_type
from
  equinix_metal_plan,
  json_each(specs, '$.cpus') as cpu;

Plans by price

Analyze the pricing structure of various plans to understand the hourly cost for each, helping you make informed decisions about which plan suits your budget best.

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

select
  name,
  json_extract(pricing, '$.hour') as hourly_cost
from
  equinix_metal_plan
order by
  hourly_cost;

Plans available by metro

Analyze the settings to understand the availability of different plans across various metropolitan areas. This is useful for assessing the distribution and accessibility of services in different urban regions.

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;

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

Schema for equinix_metal_plan

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
available_in	jsonb		Facility IDs where the plan is available.
available_in_metros	jsonb		Metro IDs where the plan is available.
class	text		Class of the plan.
deployment_types	jsonb		Deployment types for the plan.
description	text		Description of the plan.
href	text		URL of the plan.
id	text		ID of the plan.
legacy	boolean		True if this is a legacy plan.
line	text		Line of the plan.
name	text		Name of the plan.
pricing	jsonb		Pricing of the plan.
slug	text		Slug of the plan.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
specs	jsonb		Specifications of the plan.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- equinix

You can pass the configuration to the command with the --config argument:

steampipe_export_equinix --config '<your_config>' equinix_metal_plan