steampipe plugin install marekjalovec/makesteampipe plugin install marekjalovec/make

make_api_token make_connection make_data_store make_function make_hook make_organization make_organization_variable make_scenario make_scenario_dlq make_scenario_log make_team make_team_variable make_user make_user_organization_role make_user_role make_user_team_role

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

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.