Is your feature request related to a problem? Please describe.
no

Describe the solution you'd like
Equinix Metal introduced Metros as an alternative to provisioning devices (including batch, spot market, and hardware reservations), vlans, connections, and IP reservations to facilities.

The capacity and spot market prices can also be looked up by metro.

Describe alternatives you've considered
none

Additional context

A similar feature request was added for Ansible: equinix/ansible-collection-metal#30

Equinix Plugin for Steampipe

Use SQL to query infrastructure including servers, networks, facilities and more from Equinix Metal.

• Get started →
• Documentation: Table definitions & examples
• Community: Discussion forums
• Get involved: Issues

Quick start

Install the plugin with Steampipe:

steampipe plugin install equinix

Run a query:

select hostname, ip_addresses from equinix_metal_device

Developing

Prerequisites:

• Steampipe
• Golang

Clone:

git clone [email protected]:turbot/steampipe-plugin-equinix
cd steampipe-plugin-equinix

Build, which automatically installs the new version to your ~/.steampipe/plugins directory:

make

Configure the plugin:

cp config/* ~/.steampipe/config
vi ~/.steampipe/config/equinix.spc

Try it!

steampipe query
> .inspect equinix

Further reading:

• Writing plugins
• Writing your first table

Contributing

Please see the contribution guidelines and our code of conduct. All contributions are subject to the MPL-2.0 open source license.

help wanted issues:

• Steampipe
• Equinix Plugin

Equinix Metal has an API to show availability of servers in various data centers, as a "capacity" API here: https://metal.equinix.com/developers/docs/locations/capacity/

It would be useful to have some kind of interface to this endpoint.

<br> -> <br />

The Equinix Metal spot market gives you pricing for interruptible resources. The details of the service are here

https://metal.equinix.com/developers/docs/deploy/spot-market/

There are two endpoints: a "prices" endpoint that gives you a current set of spot market prices, and a "history" endpoint that gives you historical pricing information.

It would be great to see some interface to any or all of this in the plugin.

Equinix + Steampipe

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

Equinix Metal delivers global, interconnected, integrated, and on-demand bare-metal infrastructure as a service. As the name implies, these bare metal servers do not require virtualization or multi-tenancy. The provisioned infrastructure is deployed at Equinix data center locations allowing enabling direct network interconnects to other cloud providers and a global network backbone.

For example:

select 
  hostname, 
  state,
  tags
from 
  equinix_metal_device

+-----------------------+--------+---------------+
| hostname              | state  | tags          |
+-----------------------+--------+---------------+
| dc13-c3.medium.x86-01 | active | {"prod":true} |
+-----------------------+--------+---------------+

Documentation

• Table definitions & examples →

Get started

Install

Download and install the latest Equinix Metal plugin:

steampipe plugin install equinix

Credentials

Configuration

Installing the latest equinix plugin will create a config file (~/.steampipe/config/equinix.spc) with a single connection named equinix:

connection "equinix" {
  plugin  = "equinix"
  token   = "XV1JE4QXVHdCYoWT2wbr2NRdPYrZRx3N"
}

Get involved

• Open source: https://github.com/turbot/steampipe-plugin-equinix
• Community: Discussion forums

Currently it will just fail when trying to use the empty token. An empty token should be caught and raised as an error immediately as we do in other plugins.

Installation is on WSL on Windows. Here's an error I got while working through the Equinix Metal examples.

> select * from metal_device
Error: failed to populate column 'volume_ids': rpc error: code = Internal desc = transform volumesToIDs failed with panic interface conversion: interface {} is []*packngo.Volume, not []packngo.Volume

The "group devices by facility" example errors with

Error: column "count" does not exist

My account has a lot of events, and the "select * from metal_event" query is downloading them slowly in batches of 1000. I am not sure how to suspend or interrupt this call - ^C doesn't seem to register.

The suggestion would be for the example to limit the number of events retrieved.

> select * from metal_event
⠏ Loading results: 2,994