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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone	>, >=, =, <, <=	The time when the snapshot was created.
created_by	jsonb		Information about the user who created the snapshot.
created_by_id	text		The unique identifier of the user who created the snapshot.
dashboard_name	text	=, !=	The mod-prefixed name of the dashboard this snapshot belongs to.
dashboard_title	text	=, !=	The title of the dashboard this snapshot belongs to.
data	jsonb		The data for the snapshot.
expires_at	timestamp with time zone		The time when the snapshot will expire.
id	text	=, !=	The unique identifier for the snapshot.
identity_handle	text	=	The handle of the identity.
identity_id	text		The unique identifier of the identity to which the snapshot belongs to.
identity_type	text		The type of identity, can be org/user.
inputs	jsonb		The inputs used for this snapshot.
query_where	text	=	The query where expression to filter snapshots.
schema_version	text		The schema version of the underlying snapshot.
state	text		The current state of the snapshot.
tags	jsonb		The tags for the snapshot.
updated_at	timestamp with time zone		The time when the snapshot was last updated.
updated_by	jsonb		Information about the user who last updated the snapshot.
updated_by_id	text		The unique identifier of the user who last updated the snapshot.
version_id	bigint		The current version ID for the snapshot.
visibility	text	=, !=	The visibility of the snapshot.
workspace_handle	text	=	The handle of the workspace.
workspace_id	text		The unique identifier for the workspace.