steampipecloud_audit_logsteampipecloud_connectionsteampipecloud_organizationsteampipecloud_organization_membersteampipecloud_organization_workspace_membersteampipecloud_processsteampipecloud_tokensteampipecloud_usersteampipecloud_user_emailsteampipecloud_user_preferencessteampipecloud_workspacesteampipecloud_workspace_aggregatorsteampipecloud_workspace_connectionsteampipecloud_workspace_db_logsteampipecloud_workspace_modsteampipecloud_workspace_mod_variablesteampipecloud_workspace_pipelinesteampipecloud_workspace_processsteampipecloud_workspace_snapshot
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 connectionfrom steampipecloud_workspace_connection;
List workspace connections using AWS plugin
select id, connection_id, workspace_id, identity_id, jsonb_pretty(connection) as connectionfrom steampipecloud_workspace_connectionwhere connection ->> 'plugin' = 'aws';
List user workspace connections
select id, connection_id, workspace_id, identity_id, jsonb_pretty(connection) as connectionfrom steampipecloud_workspace_connectionwhere identity_id like 'u_%';
List organization workspace connections
select id, connection_id, workspace_id, identity_id, jsonb_pretty(connection) as connectionfrom steampipecloud_workspace_connectionwhere identity_id like 'o_%';
Schema for steampipecloud_workspace_connection
Name | Type | Operators | 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. |