steampipe plugin install awssteampipe plugin install aws

Table: aws_rds_db_cluster_snapshot

Amazon RDS creates a storage volume snapshot of DB cluster, backing up the entire DB cluster

Examples

List of cluster snapshots which are not encrypted

select
  db_cluster_snapshot_identifier,
  type,
  storage_encrypted,
  split_part(kms_key_id, '/', 1) kms_key_id
from
  aws_rds_db_cluster_snapshot
where
  not storage_encrypted;

Db cluster info of each snapshot

select
  db_cluster_snapshot_identifier,
  cluster_create_time,
  engine,
  engine_version,
  license_model
from
  aws_rds_db_cluster_snapshot;

Db cluster snapshot count per db cluster

select
  db_cluster_identifier,
  count(db_cluster_snapshot_identifier) snapshot_count
from
  aws_rds_db_cluster_snapshot
group by
  db_cluster_identifier;

List of manual db cluster snapshot

select
  db_cluster_snapshot_identifier,
  engine,
  type
from
  aws_rds_db_cluster_snapshot
where
  type = 'manual';

Query examples

Control examples

.inspect aws_rds_db_cluster_snapshot

AWS RDS DB Cluster Snapshot

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
allocated_storage	bigint	Specifies the allocated storage size in gibibytes (GiB).
arn	text	The Amazon Resource Name (ARN) for the DB Cluster Snapshot.
availability_zones	jsonb	A list of Availability Zones (AZs) where instances in the DB cluster snapshot can be restored.
cluster_create_time	timestamp with time zone	Specifies the time when the DB cluster was created.
create_time	timestamp with time zone	The time when the snapshot was taken.
db_cluster_identifier	text	The friendly name to identify the DB Cluster, that the snapshot snapshot was created from.
db_cluster_snapshot_attributes	jsonb	A list of DB cluster snapshot attribute names and values for a manual DB cluster snapshot.
db_cluster_snapshot_identifier	text	The friendly name to identify the DB Cluster Snapshot.
engine	text	Specifies the name of the database engine.
engine_version	text	Specifies the version of the database engine for this DB cluster snapshot.
iam_database_authentication_enabled	boolean	Specifies whether mapping of AWS Identity and Access Management (IAM) accounts to database accounts is enabled, or not.
kms_key_id	text	The AWS KMS key identifier for the AWS KMS customer master key (CMK).
license_model	text	Provides the license model information for this DB cluster snapshot.
master_user_name	text	Provides the master username for the DB cluster snapshot.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
percent_progress	bigint	Specifies the percentage of the estimated data that has been transferred.
port	bigint	Specifies the port that the DB cluster was listening on at the time of the snapshot.
region	text	The AWS Region in which the resource is located.
source_db_cluster_snapshot_arn	text	The Amazon Resource Name (ARN) for the source DB cluster snapshot, if the DB cluster snapshot was copied from a source DB cluster snapshot.
status	text	Specifies the status of this DB Cluster Snapshot.
storage_encrypted	boolean	Specifies whether the DB cluster snapshot is encrypted, or not.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags attached to the DB Cluster Snapshot.
title	text	Title of the resource.
type	text	The type of the DB Cluster Snapshot.
vpc_id	text	Provides the VPC ID associated with the DB cluster snapshot.

turbot/aws

Table: aws_rds_db_cluster_snapshot

Examples

List of cluster snapshots which are not encrypted

Db cluster info of each snapshot

Db cluster snapshot count per db cluster

List of manual db cluster snapshot

Query examples

Control examples

.inspect aws_rds_db_cluster_snapshot

Steampipe

Resources

Community