turbot/aws_insights

Query: rds_db_snapshot_overview

Usage

powerpipe query aws_insights.query.rds_db_snapshot_overview

Steampipe Tables

SQL

select
db_snapshot_identifier as "DB Snapshot Identifier",
case
when vpc_id is not null and vpc_id != '' then vpc_id
else 'N/A'
end as "VPC ID",
create_time as "Create Time",
license_model as "License Model",
engine_version as "Engine Version",
port as "Port",
title as "Title",
region as "Region",
account_id as "Account ID",
arn as "ARN"
from
aws_rds_db_snapshot
where
arn = $1;

Dashboards

The query is used in the dashboards: