steampipe plugin install pipes

Table: pipes_workspace_mod_variable - Query Pipes Workspace Mod Variables using SQL

Pipes Workspace Mod Variable is a feature within the Pipes service that allows you to manage and monitor variables within your workspace. It provides a centralized way to set up and manage variables for various resources within your workspace. Pipes Workspace Mod Variable helps you stay informed about the status and details of your variables and take appropriate actions when predefined conditions are met.

Table Usage Guide

The pipes_workspace_mod_variable table provides insights into the variables within a Pipes workspace. As a DevOps engineer, explore variable-specific details through this table, including names, descriptions, and associated metadata. Utilize it to uncover information about variables, such as their current values, default values, and whether they are required or optional.

Examples

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

Analyze the settings to understand the default and set values of all variables for a specific mod in a workspace. This is useful to validate the configuration and ensure it aligns with the intended setup.

select
id,
name,
description,
value_default,
value_setting,
value,
type
from
pipes_workspace_mod_variable
where
workspace_id = 'w_cafeina2ip835d2eoacg'
and mod_alias = 'aws_thrifty';
select
id,
name,
description,
value_default,
value_setting,
value,
type
from
pipes_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

Discover the segments that have explicit settings in a workspace mod. This is useful in understanding which variables have been specifically configured, aiding in better management and control of your workspace mods.

select
id,
name,
description,
value_default,
value_setting,
value,
type
from
pipes_workspace_mod_variable
where
workspace_id = 'w_cafeina2ip835d2eoacg'
and mod_alias = 'aws_thrifty'
and value_setting is not null;
select
id,
name,
description,
value_default,
value_setting,
value,
type
from
pipes_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

Explore the specifics of a certain variable in a workspace mod to understand its default and current values, along with its type. This is useful in assessing the configuration of the variable and its impact on the workspace mod.

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

Schema for pipes_workspace_mod_variable

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
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.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
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.
user_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier for the user.
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.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- pipes

You can pass the configuration to the command with the --config argument:

steampipe_export_pipes --config '<your_config>' pipes_workspace_mod_variable