steampipe plugin install awssteampipe plugin install aws

Table: aws_rds_db_snapshot

Amazon RDS creates a storage volume snapshot of your DB instance, backing up the entire DB instance and not just individual databases.

Examples

DB snapshot basic info

select
  db_snapshot_identifier,
  encrypted
from
  aws_rds_db_snapshot
where
  not encrypted;

List of all manual DB snapshots

select
  db_snapshot_identifier,
  type
from
  aws_rds_db_snapshot
where
  type = 'manual';

List of snapshots which are not encrypted

select
  db_snapshot_identifier,
  encrypted
from
  aws_rds_db_snapshot
where
  not encrypted;

DB instance info of each db snapshot

select
  db_snapshot_identifier,
  db_instance_identifier,
  engine,
  engine_version,
  allocated_storage,
  storage_type
from
  aws_rds_db_snapshot;

Query examples

Control examples

.inspect aws_rds_db_snapshot

AWS RDS DB 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 snapshot.
availability_zone	text	Specifies the name of the Availability Zone the DB instance was located in, at the time of the DB snapshot.
create_time	timestamp with time zone	Specifies when the snapshot was taken.
db_instance_identifier	text	Specifies the DB instance identifier of the DB instance this DB snapshot was created from.
db_snapshot_attributes	jsonb	A list of DB snapshot attribute names and values for a manual DB snapshot.
db_snapshot_identifier	text	The friendly name to identify the DB snapshot.
dbi_resource_id	text	The identifier for the source DB instance, which can't be changed and which is unique to an AWS Region.
encrypted	boolean	Specifies whether the DB snapshot is encrypted, or not.
engine	text	Specifies the name of the database engine.
engine_version	text	Specifies the version of the database engine.
iam_database_authentication_enabled	boolean	Specifies whether the mapping of AWS IAM accounts to database accounts is enabled, or not.
instance_create_time	timestamp with time zone	Specifies the time when the DB instance, from which the snapshot was taken, was created.
iops	bigint	Specifies the Provisioned IOPS (I/O operations per second) value of the DB instance at the time of the snapshot.
kms_key_id	text	Specifies the AWS KMS key identifier for the encrypted DB snapshot.
license_model	text	Specifies the License model information for the restored DB instance.
master_user_name	text	Provides the master username for the DB snapshot.
option_group_name	text	Provides the option group name for the DB snapshot.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
percent_progress	bigint	The percentage of the estimated data that has been transferred.
port	bigint	Specifies the port that the database engine was listening on at the time of the snapshot.
processor_features	jsonb	The number of CPU cores and the number of threads per core for the DB instance class of the DB instance when the DB snapshot was created.
region	text	The AWS Region in which the resource is located.
source_db_snapshot_identifier	text	The DB snapshot ARN that the DB snapshot was copied from.
source_region	text	The AWS Region that the DB snapshot was created in or copied from.
status	text	Specifies the status of this DB snapshot.
storage_type	text	Specifies the storage type associated with DB snapshot.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags attached to the DB snapshot.
tde_credential_arn	text	The ARN from the key store with which to associate the instance for TDE encryption.
timezone	text	The time zone of the DB snapshot.
title	text	Title of the resource.
type	text	Provides the type of the DB snapshot.
vpc_id	text	Provides the VPC ID associated with the DB snapshot.

turbot/aws