Table: steampipecloud_connection

Connections represent a set of tables for a single data source. Each connection is represented as a distinct Postgres schema.

Examples

select
  id,
  plugin,
  handle,
  identity_handle
from
  steampipecloud_connection;

select
  id,
  plugin,
  handle,
  jsonb_pretty(config) as config,
  identity_handle
from
  steampipecloud_connection
where
  plugin = 'aws';

select
  id,
  plugin,
  handle,
  jsonb_pretty(config) as config,
  identity_handle
from
  steampipecloud_connection
where
  identity_type = 'user';

select
  id,
  plugin,
  handle,
  jsonb_pretty(config) as config,
  identity_handle
from
  steampipecloud_connection
where
  identity_type = 'org';

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
config	jsonb		The connection config details.
created_at	timestamp with time zone		The connection created time.
created_by	jsonb		Information about the user who created the connection.
created_by_id	text		The unique identifier of the user who created the connection.
handle	text	=	The handle name for the connection.
id	text		The unique identifier for the connection.
identity_handle	text	=	The handle name for an identity where the connection has been created.
identity_id	text	=	The unique identifier for an identity where the connection has been created.
identity_type	text		The type of identity, which can be 'user' or 'org'.
plugin	text		The plugin name for the connection.
type	text		The connection type.
updated_at	timestamp with time zone		The connection's updated time.
updated_by	jsonb		Information about the user who last updated the connection.
updated_by_id	text		The unique identifier of the user who last updated the connection.
version_id	bigint		The version ID for the connection.