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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
tax_id	text		Tax ID of the organization.
title	text		Title of the resource.
twitter	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