Table: equinix_metal_project - Query Equinix Metal Projects using SQL

Equinix Metal Projects are organizational entities in the Equinix Metal platform that allow you to manage and group your resources. They provide a way to control user access, permissions, and billing. Projects are especially useful when you need to isolate resources for different environments, departments, or billing purposes.

Table Usage Guide

The equinix_metal_project table provides insights into Projects within the Equinix Metal platform. As a system administrator, you can explore project-specific details through this table, including project IDs, names, and associated metadata. Utilize it to manage and monitor your Equinix Metal resources effectively, ensuring proper access control and resource allocation.

Examples

List all projects

Explore all active projects within your organization to gain a comprehensive overview of ongoing work and resources. This can assist in effective resource allocation and project management.

select
  *
from
  equinix_metal_project;

select
  *
from
  equinix_metal_project;

Project with Organization information

Explore the association between different projects and their corresponding organizations. This can be useful to understand the organizational structure and distribution of projects within your company.

select
  p.name as project_name,
  o.name as org_name
from
  equinix_metal_project as p,
  equinix_metal_organization as o
where
  p.organization_id = o.id;

select
  p.name as project_name,
  o.name as org_name
from
  equinix_metal_project as p,
  equinix_metal_organization as o
where
  p.organization_id = o.id;

Schema for equinix_metal_project

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
backend_transfer_enabled	boolean		True if backend transfer is enabled for the project.
created_at	timestamp with time zone		When the project was created.
href	text		URL for the project.
id	text	=	ID of the project.
member_ids	jsonb		IDs of the members of this project.
name	text		Name of the project.
organization_id	text		Organization for the project.
payment_method_id	text		Payment method for the project.
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.
updated_at	timestamp with time zone		When the project was updated.

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_project