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_namefrom equinix_metal_facility as f, equinix_metal_metro as mwhere f.metro_id = m.id;
The provided PostgreSQL query does not contain any PostgreSQL specific functionsor 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_namefrom equinix_metal_facility as f, equinix_metal_metro as mwhere f.metro_id = m.id;
Schema for equinix_metal_facility
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
address | jsonb | Address of the facility. | |
akas | jsonb | Array of globally unique identifier strings (also known as) for the resource. | |
code | text | Code of the facility. | |
features | jsonb | Features of the facility. | |
href | text | URL of the facility. | |
id | text | ID of the facility. | |
metro_id | text | Metro for the facility. | |
name | text | Name of the facility. | |
tags | jsonb | A map of tags for the resource. | |
title | text | Title 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