turbot/steampipecloud
steampipe plugin install steampipecloud

Table: steampipecloud_workspace_snapshot

A Steampipe snapshot is a point in time view of a benchmark. It can be shared across workspaces or made public.

Important notes:

This table supports optional quals. Queries with optional quals in the where clause are optimised to use Steampipe Cloud filters.

Optional quals are supported for the following columns:

  • created_at
  • dashboard_name
  • dashboard_title
  • id
  • query_where - Allows use of query filters. For a list of supported columns for snapshots, please see Supported APIs and Columns. Please note that any query filter passed into the query_where qual will be combined with other optional quals.
  • visibility

Examples

Basic info

select
id,
identity_handle,
workspace_handle,
state,
visibility,
dashboard_name,
dashboard_title,
schema_version,
tags
from
steampipecloud_workspace_snapshot;

List snapshots for a specific workspace

select
id,
identity_handle,
workspace_handle,
state,
visibility,
dashboard_name,
dashboard_title,
schema_version,
tags
from
steampipecloud_workspace_snapshot
where
workspace_handle = 'dev';

List public snapshots for the AWS Tags Limit benchmark dashboard across all workspaces

select
id,
identity_handle,
workspace_handle,
state,
visibility,
dashboard_name,
dashboard_title,
schema_version,
tags
from
steampipecloud_workspace_snapshot
where
dashboard_name = 'aws_tags.benchmark.limit'
and visibility = 'anyone_with_link';

List snapshots for the AWS Compliance CIS v1.4.0 dashboard executed in the last 7 days

select
id,
identity_handle,
workspace_handle,
state,
visibility,
dashboard_name,
dashboard_title,
schema_version,
tags
from
steampipecloud_workspace_snapshot
where
dashboard_name = 'aws_compliance.benchmark.cis_v140'
and created_at >= now() - interval '7 days';

Get the raw data for a particular snapshot

select
data
from
steampipecloud_workspace_snapshot
where
identity_handle = 'myuser'
and workspace_handle = 'dev'
and id = 'snap_cc1ini7m1tujk0r0oqvg_12fie4ah78yl5rwadj7p6j63';

List snapshots for the AWS Tags Limit benchmark dashboard executed in the last 7 days using query filter

select
id,
identity_handle,
workspace_handle,
state,
visibility,
dashboard_name,
dashboard_title,
schema_version,
tags
from
steampipecloud_workspace_snapshot
where
query_where = 'dashboard_name = ''aws_tags.benchmark.limit'' and created_at >= now() - interval ''7 days''';

Schema for steampipecloud_workspace_snapshot

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zone>, >=, =, <, <=The time when the snapshot was created.
created_byjsonbInformation about the user who created the snapshot.
created_by_idtextThe unique identifier of the user who created the snapshot.
dashboard_nametext=, !=The mod-prefixed name of the dashboard this snapshot belongs to.
dashboard_titletext=, !=The title of the dashboard this snapshot belongs to.
datajsonbThe data for the snapshot.
expires_attimestamp with time zoneThe time when the snapshot will expire.
idtext=, !=The unique identifier for the snapshot.
identity_handletext=The handle of the identity.
identity_idtextThe unique identifier of the identity to which the snapshot belongs to.
identity_typetextThe type of identity, can be org/user.
inputsjsonbThe inputs used for this snapshot.
query_wheretext=The query where expression to filter snapshots.
schema_versiontextThe schema version of the underlying snapshot.
statetextThe current state of the snapshot.
tagsjsonbThe tags for the snapshot.
updated_attimestamp with time zoneThe time when the snapshot was last updated.
updated_byjsonbInformation about the user who last updated the snapshot.
updated_by_idtextThe unique identifier of the user who last updated the snapshot.
version_idbigintThe current version ID for the snapshot.
visibilitytext=, !=The visibility of the snapshot.
workspace_handletext=The handle of the workspace.
workspace_idtextThe unique identifier for the workspace.