Table: make_organization
Organizations are main containers that contain all teams, scenarios, and users.
Key columns
- Provide a numeric
id
if you want to query for a specific Organization.
Examples
List of all Organizations in the account
select id, namefrom make_organizationorder by name;
Detail of an Organization
select id, name, country_id, timezone_id, license, zone, service_name, is_paused, external_idfrom make_organizationwhere id = 1;
Schema for make_organization
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
country_id | bigint | The ID of the country associated with the Organization. | |
external_id | text | Make private instances use the externalId parameter for security reasons. | |
id | bigint | = | The organization ID. |
is_paused | boolean | Is the Organization paused? | |
license | jsonb | Licence information and limits. | |
name | text | The name of the Organization. | |
service_name | text | Service name. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
timezone_id | bigint | The ID of the timezone associated with the Organization. | |
title | text | The display name for the resource. | |
zone | text | Zone where the Organization exists. |