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

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
connection	jsonb	Additional information about the connection.
connection_handle	text	The handle for the connection.
connection_id	text	The unique identifier for the connection.
created_at	timestamp with time zone	The time when the connection was added to the workspace.
created_by	jsonb	Information about the user who added the connection to the workspace.
created_by_id	text	The unique identifier of the user who added the connection to the workspace.
id	text	The unique identifier for the association.
identity_handle	text	The handle of the identity.
identity_id	text	The unique identifier of the identity.
identity_type	text	The type of identity. Can be one of 'user' or 'org'
updated_at	timestamp with time zone	The time when the association was last updated.
updated_by	jsonb	Information about the user who last updated the association.
updated_by_id	text	The unique identifier of the user who last updated the association.
version_id	bigint	The current version ID for the association.
workspace_handle	text	The handle for the workspace.
workspace_id	text	The 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