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	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
is_system	boolean		Is the Team Variable set by Make, or by users?
name	text		The name of the Team Variable.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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.