turbot/steampipecloud
steampipe plugin install steampipecloud

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
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'
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.
version_idbigintThe current version ID for the association.
workspace_handletextThe handle for the workspace.
workspace_idtextThe unique identifier for the workspace.