turbot/aws_insights

Query: redshift_snapshot_overview

Usage

powerpipe query aws_insights.query.redshift_snapshot_overview

Steampipe Tables

SQL

select
snapshot_identifier as "Snapshot Name",
cluster_identifier as "Cluster Name",
title as "Title",
snapshot_create_time as "Create Date",
engine_full_version as "Engine Version",
vpc_id as "VPC ID",
manual_snapshot_remaining_days as "Manual Snapshot Remaining Days",
availability_zone as "Availability Zone",
region as "Region",
account_id as "Account ID"
from
aws_redshift_snapshot
where
akas::text = $1;

Dashboards

The query is used in the dashboards: