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_namefrom equinix_metal_project as p, equinix_metal_organization as owhere p.organization_id = o.id;
select p.name as project_name, o.name as org_namefrom equinix_metal_project as p, equinix_metal_organization as owhere p.organization_id = o.id;
Schema for equinix_metal_project
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
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. | |
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