Table: equinix_metal_capacity - Query Equinix Metal Capacities using SQL

Equinix Metal is a bare metal cloud service that provides physical servers with the automation and flexibility of a virtual machine. The service offers a range of server types for different workloads and needs, from single-tenant servers for maximum privacy and performance, to multi-tenant servers for cost-effective scaling. It is a globally distributed platform with data centers in multiple locations around the world.

Table Usage Guide

The equinix_metal_capacity table provides insights into available and utilized capacities within Equinix Metal. As a cloud architect or system administrator, explore capacity-specific details through this table, including available and utilized server types, plan slugs, and associated metadata. Utilize it to monitor resource usage, manage capacity planning, and optimize the allocation of resources.

Examples

List all capacities

Discover the segments that allow you to analyze available resources within different facilities and plans, helping you manage and allocate resources effectively.

select
  *
from
  equinix_metal_capacity
order by
  facility,
  plan;

select
  *
from
  equinix_metal_capacity
order by
  facility,
  plan;

Show all servers with limited capacity

Discover the segments that are operating at a limited capacity in your infrastructure. This is particularly useful for planning resources and preventing potential shortages.

select
  facility,
  plan
from
  equinix_metal_capacity
where
  level = 'limited'
order by
  facility,
  plan;

select
  facility,
  plan
from
  equinix_metal_capacity
where
  level = 'limited'
order by
  facility,
  plan;

Schema for equinix_metal_capacity

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
facility	text		Facility code.
level	text		Current capacity level: normal, limited or unavailable.
plan	text		Server type.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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_capacity