steampipe plugin install pipes

Table: pipes_workspace_connection - Query Pipes Workspace Connections using SQL

Pipes Workspace Connection is a resource within the Steampipe Pipes plugin that represents a connection within a workspace. It provides details about each individual connection, including its ID, name, and associated workspace. This resource is crucial for managing and understanding the connections within a workspace in Steampipe Pipes.

Table Usage Guide

The pipes_workspace_connection table provides insights into the connections within a workspace in Steampipe Pipes. As a DevOps engineer, explore connection-specific details through this table, including connection ID, name, and associated workspace. Utilize it to uncover information about connections, such as their details, the workspaces they are associated with, and other metadata.

Examples

Basic info

Explore the connections established within your workspace by identifying the unique identifiers associated with each connection. This can be particularly useful to assess and manage the various connections in a larger workspace setup.

select
id,
connection_id,
workspace_id,
identity_id,
jsonb_pretty(connection) as connection
from
pipes_workspace_connection;
select
id,
connection_id,
workspace_id,
identity_id,
connection
from
pipes_workspace_connection;

List workspace connections using AWS plugin

Discover the segments that utilize the AWS plugin within your workspace connections. This is useful for understanding how many and which connections are specifically associated with AWS, thereby aiding in resource allocation and management.

select
id,
connection_id,
workspace_id,
identity_id,
jsonb_pretty(connection) as connection
from
pipes_workspace_connection
where
connection ->> 'plugin' = 'aws';
select
id,
connection_id,
workspace_id,
identity_id,
connection
from
pipes_workspace_connection
where
json_extract(connection, '$.plugin') = 'aws';

List user workspace connections

Explore which user workspace connections exist, focusing on those that have a specific identity ID pattern. This can be beneficial for managing and understanding the relationships between users, their workspaces, and their connections.

select
id,
connection_id,
workspace_id,
identity_id,
jsonb_pretty(connection) as connection
from
pipes_workspace_connection
where
identity_id like 'u_%';
select
id,
connection_id,
workspace_id,
identity_id,
connection
from
pipes_workspace_connection
where
identity_id like 'u_%';

List organization workspace connections

Explore which organization workspace connections are in use. This can help in understanding the interdependencies and managing resources more effectively.

select
id,
connection_id,
workspace_id,
identity_id,
jsonb_pretty(connection) as connection
from
pipes_workspace_connection
where
identity_id like 'o_%';
select
id,
connection_id,
workspace_id,
identity_id,
connection
from
pipes_workspace_connection
where
identity_id like 'o_%';

Schema for pipes_workspace_connection

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
connectionjsonbAdditional information about the connection.
connection_handletextThe handle for the connection.
connection_idtextThe unique identifier for the connection.
created_attimestamp with time zoneThe time when the connection was added to the workspace.
created_byjsonbInformation about the user who added the connection to the workspace.
created_by_idtextThe unique identifier of the user who added the connection to the workspace.
idtextThe unique identifier for the association.
identity_handletextThe handle of the identity.
identity_idtextThe unique identifier of the identity.
identity_typetextThe type of identity. Can be one of 'user' or 'org'
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
updated_attimestamp with time zoneThe time when the association was last updated.
updated_byjsonbInformation about the user who last updated the association.
updated_by_idtextThe unique identifier of the user who last updated the association.
user_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier for the user.
version_idbigintThe current version ID for the association.
workspace_handletextThe handle for the workspace.
workspace_idtextThe unique identifier for the workspace.

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_connection