Table: steampipecloud_workspace_aggregator

Aggregators allow users to aggregate or search for data across multiple connections in a workspace.

Examples

Basic info

select
  id,
  handle,
  identity_handle,
  workspace_handle,
  type,
  plugin,
  connections
from
  steampipecloud_workspace_aggregator;

List aggregators for a specific workspace

select
  id,
  handle,
  identity_handle,
  workspace_handle,
  type,
  plugin,
  connections
from
  steampipecloud_workspace_aggregator
where
  workspace_handle = 'dev';

List aggregators of plugin type `aws` for a specific workspace

select
  id,
  handle,
  identity_handle,
  workspace_handle,
  type,
  plugin,
  connections
from
  steampipecloud_workspace_aggregator
where
  workspace_handle = 'dev'
  and plugin = 'aws';

List aggregators created in the last 7 days for a specific workspace

select
  id,
  handle,
  identity_handle,
  workspace_handle,
  type,
  plugin,
  connections
from
  steampipecloud_workspace_aggregator
where
  workspace_handle = 'dev'
  and created_at >= now() - interval '7 days';

Schema for steampipecloud_workspace_aggregator

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
connections	jsonb		The list of connections defined for the aggregator.
created_at	timestamp with time zone		The time when the aggregator was created.
created_by	jsonb		Information about the user who created the aggregator.
created_by_id	text		The unique identifier of the user who created the aggregator.
handle	text	=	The handle of the aggregator.
id	text		The unique identifier for the aggregator.
identity_handle	text	=	The handle of the identity.
identity_id	text	=	The unique identifier of the identity to which the aggregator belongs to.
identity_type	text		The type of identity, can be org/user.
plugin	text		The type of the aggregator connections.
type	text		The type of the resource.
updated_at	timestamp with time zone		The time when the aggregator was last updated.
updated_by	jsonb		Information about the user who last updated the aggregator.
updated_by_id	text		The unique identifier of the user who last updated the aggregator.
version_id	bigint		The current version ID for the aggregator.
workspace_handle	text	=	The handle of the workspace.
workspace_id	text	=	The unique identifier for the workspace.

Table: steampipecloud_workspace_aggregator

Examples

Basic info

List aggregators for a specific workspace

List aggregators of plugin type aws for a specific workspace

List aggregators created in the last 7 days for a specific workspace

Schema for steampipecloud_workspace_aggregator

List aggregators of plugin type `aws` for a specific workspace