steampipe plugin install marekjalovec/make

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,
name
from
make_organization
order by
name;

Detail of an Organization

select
id,
name,
country_id,
timezone_id,
license,
zone,
service_name,
is_paused,
external_id
from
make_organization
where
id = 1;

Schema for make_organization

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
country_idbigintThe ID of the country associated with the Organization.
external_idtextMake private instances use the externalId parameter for security reasons.
idbigint=The organization ID.
is_pausedbooleanIs the Organization paused?
licensejsonbLicence information and limits.
nametextThe name of the Organization.
service_nametextService name.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
timezone_idbigintThe ID of the timezone associated with the Organization.
titletextThe display name for the resource.
zonetextZone where the Organization exists.