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_team_variable

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

Key columns

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

Examples

List of all custom Team Variables available in the account

select
  o.name organization_name,
  t.name team_name,
  tv.name variable_name,
  tv.value variable_value
from
  make_organization o
  join make_team t on t.organization_id = o.id
  join make_team_variable tv on tv.team_id = t.id
where
  tv.is_system = false;

List of all Bearer tokens

select
  o.name organization_name,
  t.name team_name,
  tv.name variable_name,
  tv.value variable_value
from
  make_organization o
  join make_team t on t.organization_id = o.id
  join make_team_variable tv on tv.team_id = t.id
where
  tv.is_system = false
  and tv.value like 'Bearer %';

Schema for make_team_variable

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
is_system	boolean	Is the Team Variable set by Make, or by users?
name	text	The name of the Team Variable.
team_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 Team Variable.
value	text	The value of the Team Variable, converted to string.