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	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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