steampipe plugin install equinix

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_name
from
equinix_metal_organization as o,
jsonb_array_elements_text(o.project_ids) as opid,
equinix_metal_project as p
where
p.id = opid;
select
o.id as org_id,
o.name as org_name,
p.id as project_id,
p.name as project_name
from
equinix_metal_organization as o,
json_each(o.project_ids) as opid,
equinix_metal_project as p
where
p.id = opid.value;

Schema for equinix_metal_organization

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
addressjsonbAddress of the organization.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
billing_phonetextBilling phone number of the organization.
created_attimestamp with time zoneWhen the organization was created.
credit_amountdouble precisionCredit amount available to the organization.
descriptiontextDescription for the organization.
hreftextURL for the organization.
idtext=ID of the organization.
logotextLogo of the organization.
logo_thumbtextLogo thumbnail of the organization.
main_phonetextMain phone number of the organization.
member_idsjsonbIDs of the members of this organization.
nametextName of the organization.
owner_idsjsonbIDs of the owners of this organization.
project_idsjsonbProjects for the organization.
tagsjsonbA map of tags for the resource.
tax_idtextTax ID of the organization.
titletextTitle of the resource.
twittertextTwitter handle for the organization.
updated_attimestamp with time zoneWhen the organization was updated.
websitetextWebsite 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