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_variable

Organization Variables are user-set variables you can use in your scenarios.

Key columns

Provide a numeric organization_id to query Organization Variables for a specific Organization. This can be either set directly in a where clause, or specified as part of join with another table.

Examples

List of all custom Organization Variables available in the account

select
  o.name organization_name,
  ov.name variable_name,
  ov.value variable_value
from
  make_organization o
  join make_organization_variable ov on ov.organization_id = o.id
where
  ov.is_system = false;

List of all API endpoints

select
  o.name organization_name,
  ov.name variable_name,
  ov.value variable_value
from
  make_organization o
  join make_organization_variable ov on ov.organization_id = o.id
where
  ov.is_system = false
  and ov.value like '%api%';

Schema for make_organization_variable

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
is_system	boolean		Is the Organization Variable set by Make, or by users?
name	text		The name of the Organization Variable.
organization_id	bigint		Virtual column, used to map the entity to another object.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		The display name for the resource.
type_id	bigint		Original data type of the Organization Variable.
value	text		The value of the Organization Variable, converted to string.