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

Name	Type	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