turbot/aws_insights

Query: dynamodb_table_point_in_time_recovery

Usage

powerpipe query aws_insights.query.dynamodb_table_point_in_time_recovery

Steampipe Tables

SQL

select
point_in_time_recovery_description ->> 'PointInTimeRecoveryStatus' as "Status",
point_in_time_recovery_description ->> 'EarliestRestorableDateTime' as "Earliest Restorable Date",
point_in_time_recovery_description ->> 'LatestRestorableDateTime' as "Latest Restorable Date"
from
aws_dynamodb_table
where
arn = $1
and region = split_part($1, ':', 4)
and account_id = split_part($1, ':', 5);

Dashboards

The query is used in the dashboards: