turbot/steampipecloud
steampipe plugin install steampipecloud

Table: steampipecloud_workspace_mod_variable

Variables are module level objects that allow you to pass values to your module at runtime. When running Steampipe, you can pass values on the command line or from a .spvars file, and you will be prompted for any variables that have no values.

Examples

List basic information for all variables for a mod in a workspace

select
id,
name,
description,
value_default,
value_setting,
value,
type
from
steampipecloud_workspace_mod_variable
where
workspace_id = 'w_cafeina2ip835d2eoacg'
and mod_alias = 'aws_thrifty';

List all variables which have an explicit setting in a workspace mod

select
id,
name,
description,
value_default,
value_setting,
value,
type
from
steampipecloud_workspace_mod_variable
where
workspace_id = 'w_cafeina2ip835d2eoacg'
and mod_alias = 'aws_thrifty'
and value_setting is not null;

List details about a particular variable in a workspace mod

select
id,
name,
description,
value_default,
value_setting,
value,
type
from
steampipecloud_workspace_mod_variable
where
workspace_id = 'w_cafeina2ip835d2eoacg'
and mod_alias = 'aws_tags'
and name = 'mandatory_tags';

Schema for steampipecloud_workspace_mod_variable

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zoneTime when the mod variable was created.
created_byjsonbInformation about the user who created the Setting.
created_by_idtextUnique identifier of the user who created the setting.
descriptiontextDescription of the variable.
idtextThe unique identifier for the workspace mod variable.
mod_aliastext=The alias of the mod to which the variable belongs to.
nametextName of the variable.
typetextType of value expected by the variable.
updated_attimestamp with time zoneTime when the mod variable was last updated.
updated_byjsonbInformation about the user who updated the Setting.
updated_by_idtextUnique identifier of the user who last updated the setting.
valuejsonbWinning Value of the variable.
value_defaultjsonbDefault Value of the variable.
value_settingjsonbAn explicit setting defined for the variable.
version_idbigintThe current version ID of the variable.
workspace_idtext=The identifier of the workspace to which the variable belongs.