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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		Time when the mod variable was created.
created_by	jsonb		Information about the user who created the Setting.
created_by_id	text		Unique identifier of the user who created the setting.
description	text		Description of the variable.
id	text		The unique identifier for the workspace mod variable.
mod_alias	text	=	The alias of the mod to which the variable belongs to.
name	text		Name of the variable.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
type	text		Type of value expected by the variable.
updated_at	timestamp with time zone		Time when the mod variable was last updated.
updated_by	jsonb		Information about the user who updated the Setting.
updated_by_id	text		Unique identifier of the user who last updated the setting.
user_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier for the user.
value	jsonb		Winning Value of the variable.
value_default	jsonb		Default Value of the variable.
value_setting	jsonb		An explicit setting defined for the variable.
version_id	bigint		The current version ID of the variable.
workspace_id	text	=	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