steampipe plugin install equinix

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
backend_transfer_enabledbooleanTrue if backend transfer is enabled for the project.
created_attimestamp with time zoneWhen the project was created.
hreftextURL for the project.
idtext=ID of the project.
member_idsjsonbIDs of the members of this project.
nametextName of the project.
organization_idtextOrganization for the project.
payment_method_idtextPayment method for the project.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
updated_attimestamp with time zoneWhen 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