v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Hub

Plugins Mods Docs Home

Plugins

marekjalovec/make

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	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
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.