steampipe plugin install awssteampipe plugin install aws

Table: aws_neptune_db_cluster

An Amazon Neptune DB cluster manages access to your data through queries.

Note: This table only returns Neptune DB clusters, not RDS or DocumentDB DB clusters.

Examples

List of DB clusters which are not encrypted

select
  db_cluster_identifier,
  allocated_storage,
  kms_key_id
from
  aws_neptune_db_cluster
where
  kms_key_id is null;

List of DB clusters where backup retention period is greater than 7 days

select
  db_cluster_identifier,
  backup_retention_period
from
  aws_neptune_db_cluster
where
  backup_retention_period > 7;

Avalability zone count for each db instance

select
  db_cluster_identifier,
  jsonb_array_length(availability_zones) availability_zones_count
from
  aws_neptune_db_cluster;

DB cluster Members info

select
  db_cluster_identifier,
  member ->> 'DBClusterParameterGroupStatus' as db_cluster_parameter_group_status,
  member ->> 'DBInstanceIdentifier' as db_instance_identifier,
  member ->> 'IsClusterWriter' as is_cluster_writer,
  member ->> 'PromotionTier' as promotion_tier
from
  aws_neptune_db_cluster
  cross join jsonb_array_elements(db_cluster_members) as member;

.inspect aws_neptune_db_cluster

AWS Neptune DB Cluster

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	AllocatedStorage always returns 1, because Neptune DB cluster storage size is not fixed, but instead automatically adjusts as needed.
arn	text	The Amazon Resource Name (ARN) for the DB cluster.
associated_roles	jsonb	Provides a list of the Amazon Identity and Access Management (IAM) roles.
automatic_restart_time	timestamp with time zone	Time at which the DB cluster will be automatically restarted.
availability_zones	jsonb	Provides the list of EC2 Availability Zones that instances in the DB cluster can be created in.
backup_retention_period	bigint	Specifies the number of days for which automatic DB snapshots are retained.
clone_group_id	text	Identifies the clone group to which the DB cluster is associated.
cluster_create_time	timestamp with time zone	Specifies the time when the DB cluster was created, in Universal Coordinated Time (UTC).
copy_tags_to_snapshot	boolean	If set to true, tags are copied to any snapshot of the DB cluster that is created.
cross_account_clone	boolean	If set to true, the DB cluster can be cloned across accounts.
database_name	text	Contains the name of the initial database of this DB cluster that was provided.
db_cluster_identifier	text	Contains a user-supplied DB cluster identifier. This identifier is the unique key that identifies a DB cluster.
db_cluster_members	jsonb	Provides the list of instances that make up the DB cluster.
db_cluster_parameter_group	text	Specifies the name of the DB cluster parameter group for the DB cluster.
db_cluster_resource_id	text	The Amazon Region-unique, immutable identifier for the DB cluster.
db_subnet_group	text	Specifies information on the subnet group associated with the DB cluster.
deletion_protection	boolean	Indicates whether or not the DB cluster has deletion protection enabled.
earliest_restorable_time	timestamp with time zone	Specifies the earliest time to which a database can be restored with point-in-time restore.
enabled_cloudwatch_logs_exports	jsonb	A list of log types that this DB cluster is configured to export to CloudWatch Logs.
endpoint	text	Specifies the connection endpoint for the primary instance of the DB cluster.
engine	text	Provides the name of the database engine to be used for this DB cluster.
engine_version	text	Indicates the database engine version.
hosted_zone_id	text	Specifies the ID that Amazon Route 53 assigns when you create a hosted zone.
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.
latest_restorable_time	timestamp with time zone	Specifies the latest time to which a database can be restored with point-in-time restore.
multi_az	boolean	Specifies whether the DB cluster has instances in multiple Availability Zones.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
percent_progress	text	Specifies the progress of the operation as a percentage.
port	bigint	Specifies the port that the database engine is listening on.
preferred_backup_window	text	Specifies the daily time range during which automated backups are created if automated backups are enabled, as determined by the BackupRetentionPeriod.
preferred_maintenance_window	text	Specifies the weekly time range during which system maintenance can occur, in Universal Coordinated Time (UTC).
read_replica_identifiers	jsonb	Contains one or more identifiers of the Read Replicas associated with this DB cluster.
reader_endpoint	text	The reader endpoint for the DB cluster.
region	text	The AWS Region in which the resource is located.
status	text	Specifies the current state of this DB cluster.
storage_encrypted	boolean	Specifies whether the DB cluster is encrypted.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags assigned to the resource.
title	text	Title of the resource.
vpc_security_groups	jsonb	Provides a list of VPC security groups that the DB cluster belongs to.

turbot/aws