steampipe plugin install aws

Table: aws_dynamodb_backup - Query AWS DynamoDB Backup using SQL

The AWS DynamoDB Backup service provides on-demand and continuous backups of your DynamoDB tables, safeguarding your data for archival and disaster recovery. It enables point-in-time recovery, allowing you to restore your table data from any second in the past 35 days. This service also supports backup and restore actions through AWS Management Console, AWS CLI, and AWS SDKs.

Table Usage Guide

The aws_dynamodb_backup table in Steampipe provides you with information about backups in AWS DynamoDB. This table allows you, as a DevOps engineer, to query backup-specific details, including backup ARN, backup creation date, backup size, backup status, and more. You can utilize this table to gather insights on backups, such as backup status, backup type, size in bytes, and more. The schema outlines the various attributes of the DynamoDB backup for you, including the backup ARN, backup creation date, backup size, backup status, and more.

Examples

List backups with their corresponding tables

Determine the areas in which backups are associated with their corresponding tables in the AWS DynamoDB service. This can be useful for understanding the relationship between backups and tables, aiding in efficient data management and disaster recovery planning.

select
name,
table_name,
table_id
from
aws_dynamodb_backup;
select
name,
table_name,
table_id
from
aws_dynamodb_backup;

Basic backup info

Assess the elements within your AWS DynamoDB backup, such as status, type, expiry date, and size. This allows you to manage and optimize your backup strategy effectively.

select
name,
backup_status,
backup_type,
backup_expiry_datetime,
backup_size_bytes
from
aws_dynamodb_backup;
select
name,
backup_status,
backup_type,
backup_expiry_datetime,
backup_size_bytes
from
aws_dynamodb_backup;

Schema for aws_dynamodb_backup

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntext=Amazon Resource Name associated with the backup.
backup_creation_datetimetimestamp with time zoneTime at which the backup was created.
backup_expiry_datetimetimestamp with time zoneTime at which the automatic on-demand backup created by DynamoDB will expire.
backup_size_bytesbigintSize of the backup in bytes.
backup_statustextCurrent status of the backup. Backup can be in one of the following states: CREATING, ACTIVE, DELETED.
backup_typetext=Backup type (USER | SYSTEM | AWS_BACKUP).
nametextName of the backup.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
table_arntextName of the table to which backup belongs.
table_idtextARN associated with the table to which backup belongs.
table_nametext=Unique identifier for the table to which backup belongs.
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_dynamodb_backup