turbot/alicloud_insights

Query: rds_instance_overview

Usage

powerpipe query alicloud_insights.query.rds_instance_overview

Steampipe Tables

SQL

select
db_instance_id as "DB Instance ID",
case
when vpc_id is not null and vpc_id != '' then vpc_id
else 'N/A'
end as "VPC ID",
creation_time as "Create Time",
db_instance_class as "Instance Class",
db_instance_type as "Instance Type",
pay_type as "Pay Type",
title as "Title",
region as "Region",
account_id as "Account ID",
instance_network_type as "Instance Network Type",
arn as "ARN"
from
alicloud_rds_instance
where
arn = $1
and account_id = split_part($1,':',5)
and region = split_part($1,':',4);

Dashboards

The query is used in the dashboards: