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;

Query examples

Schema for aws_dynamodb_backup

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
arn	text	=	Amazon Resource Name associated with the backup.
backup_creation_datetime	timestamp with time zone		Time at which the backup was created.
backup_expiry_datetime	timestamp with time zone		Time at which the automatic on-demand backup created by DynamoDB will expire.
backup_size_bytes	bigint		Size of the backup in bytes.
backup_status	text		Current status of the backup. Backup can be in one of the following states: CREATING, ACTIVE, DELETED.
backup_type	text	=	Backup type (USER \| SYSTEM \| AWS_BACKUP).
name	text		Name of the backup.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text		The AWS Region in which the resource is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
table_arn	text		Name of the table to which backup belongs.
table_id	text		ARN associated with the table to which backup belongs.
table_name	text	=	Unique identifier for the table to which backup belongs.
title	text		Title 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