steampipe plugin install equinix

Table: equinix_metal_facility - Query Equinix Metal Facilities using SQL

Equinix Metal is a bare metal cloud service that allows you to deploy physical infrastructure at global scale. Equinix Metal Facilities refer to the physical locations around the world where Equinix Metal services are available. These facilities provide the necessary infrastructure for the deployment of physical servers, storage, and networking resources.

Table Usage Guide

The equinix_metal_facility table provides insights into Equinix Metal Facilities. As a system administrator or infrastructure manager, you can explore facility-specific details through this table, including location, features, and available capacity. Use it to plan and manage your Equinix Metal deployments, ensuring optimal location selection and resource allocation.

Examples

List all Equinix Metal facilities

Discover the segments that comprise all the Equinix Metal facilities. This would be beneficial for understanding the overall infrastructure and distribution of resources within your network.

select
*
from
equinix_metal_facility;
select
*
from
equinix_metal_facility;

Get metro information for each facility

Explore the geographical relationship between facilities and metros. This query is useful for understanding where each facility is located in relation to metropolitan areas, which can help in planning logistics or assessing service coverage areas.

select
f.name as facility_name,
m.name as metro_name
from
equinix_metal_facility as f,
equinix_metal_metro as m
where
f.metro_id = m.id;
The provided PostgreSQL query does not contain any PostgreSQL specific functions
or data types that need to be converted to SQLite.The query can be used as is in SQLite.select f.name as facility_name,
m.name as metro_name
from
equinix_metal_facility as f,
equinix_metal_metro as m
where
f.metro_id = m.id;

Schema for equinix_metal_facility

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
addressjsonbAddress of the facility.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
codetextCode of the facility.
featuresjsonbFeatures of the facility.
hreftextURL of the facility.
idtextID of the facility.
metro_idtextMetro for the facility.
nametextName of the facility.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.

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_facility