Table: equinix_metal_organization - Query Equinix Metal Organizations using SQL
Equinix Metal Organizations are a fundamental resource in the Equinix Metal cloud infrastructure platform. They represent a collection of users, with billing and permissions managed at the organization level. Organizations are the top level of the Equinix Metal resource hierarchy, and they contain projects which in turn contain the resources.
Table Usage Guide
The equinix_metal_organization
table provides insights into Equinix Metal Organizations within the Equinix Metal cloud infrastructure platform. As a cloud engineer or administrator, explore organization-specific details through this table, including ID, name, description, and created and updated timestamps. Utilize it to uncover information about organizations, such as their associated users, billing details, and permission settings.
Examples
List all organizations
Explore the various organizations within your Equinix Metal account to understand their structure and relationships. This is useful for managing and organizing resources within a large account.
select *from equinix_metal_organization;
select *from equinix_metal_organization;
List all projects for the organization
Explore which projects are associated with your organization. This is useful for gaining a comprehensive view of all ongoing projects, allowing for better management and coordination.
select o.id as org_id, o.name as org_name, p.id as project_id, p.name as project_namefrom equinix_metal_organization as o, jsonb_array_elements_text(o.project_ids) as opid, equinix_metal_project as pwhere p.id = opid;
select o.id as org_id, o.name as org_name, p.id as project_id, p.name as project_namefrom equinix_metal_organization as o, json_each(o.project_ids) as opid, equinix_metal_project as pwhere p.id = opid.value;
Schema for equinix_metal_organization
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
address | jsonb | Address of the organization. | |
akas | jsonb | Array of globally unique identifier strings (also known as) for the resource. | |
billing_phone | text | Billing phone number of the organization. | |
created_at | timestamp with time zone | When the organization was created. | |
credit_amount | double precision | Credit amount available to the organization. | |
description | text | Description for the organization. | |
href | text | URL for the organization. | |
id | text | = | ID of the organization. |
logo | text | Logo of the organization. | |
logo_thumb | text | Logo thumbnail of the organization. | |
main_phone | text | Main phone number of the organization. | |
member_ids | jsonb | IDs of the members of this organization. | |
name | text | Name of the organization. | |
owner_ids | jsonb | IDs of the owners of this organization. | |
project_ids | jsonb | Projects for the organization. | |
tags | jsonb | A map of tags for the resource. | |
tax_id | text | Tax ID of the organization. | |
title | text | Title of the resource. | |
text | Twitter handle for the organization. | ||
updated_at | timestamp with time zone | When the organization was updated. | |
website | text | Website for the organization. |
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_organization