steampipe plugin install awssteampipe plugin install aws

Table: aws_neptune_db_cluster_snapshot

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

Examples

List of DB cluster snapshots which are not encrypted

select
  db_cluster_snapshot_identifier,
  snapshot_type,
  storage_encrypted
from
  aws_neptune_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_neptune_db_cluster_snapshot;

DB cluster snapshot count per DB cluster

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

List of publicly restorable DB cluster snapshots

select
  db_cluster_snapshot_identifier,
  engine,
  snapshot_type
from
  aws_neptune_db_cluster_snapshot,
  jsonb_array_elements(db_cluster_snapshot_attributes) as cluster_snapshot
where
  cluster_snapshot -> 'AttributeValues' = '["all"]';

.inspect aws_neptune_db_cluster_snapshot

AWS Neptune 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).
availability_zones	jsonb	Provides the list of EC2 Availability Zones that instances in the DB cluster snapshot can be restored in.
cluster_create_time	timestamp with time zone	Specifies the time when the DB cluster was created, in Universal Coordinated Time (UTC).
db_cluster_identifier	text	Specifies the DB cluster identifier of the DB cluster that this DB cluster snapshot was created from.
db_cluster_snapshot_arn	text	The Amazon Resource Name (ARN) for the DB cluster snapshot.
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	Specifies the identifier for a DB cluster snapshot. Must match the identifier of an existing snapshot.
engine	text	Specifies the name of the database engine.
engine_version	text	Provides the version of the database engine for this DB cluster snapshot.
iam_database_authentication_enabled	boolean	True if mapping of Amazon Identity and Access Management (IAM) accounts to database accounts is enabled, and otherwise false.
kms_key_id	text	If StorageEncrypted is true, the Amazon KMS key identifier for the encrypted DB cluster snapshot.
license_model	text	Provides the license model information for this DB cluster snapshot.
master_username	text	Not supported by Neptune.
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.
snapshot_create_time	timestamp with time zone	Provides the time when the snapshot was taken, in Universal Coordinated Time (UTC).
snapshot_type	text	Provides the type of the DB cluster snapshot.
source_db_cluster_snapshot_arn	text	If the DB cluster snapshot was copied from a source DB cluster snapshot, the Amazon Resource Name (ARN) for the source DB cluster snapshot, otherwise, a null value.
status	text	Specifies the status of this DB cluster snapshot.
storage_encrypted	boolean	Specifies whether the DB cluster snapshot is encrypted.
title	text	Title of the resource.
vpc_id	text	Provides the VPC ID associated with the DB cluster snapshot.

turbot/aws