Table: steampipecloud_workspace_connection

Workspace connections are the associations between workspaces and connections.

Examples

Basic info

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

List workspace connections using AWS plugin

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

List user workspace connections

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

List organization workspace connections

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

Schema for steampipecloud_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.