turbot/gcp_insights

Query: sql_database_instance_overview

Usage

powerpipe query gcp_insights.query.sql_database_instance_overview

SQL

select
database_version as "Database Version",
instance_type as "Instance Type",
pricing_plan as "Pricing Plan",
case
when storage_auto_resize then 'Enabled'
else 'Disabled'
end as "Auto Resize",
machine_type as "Machine Type",
title as "Title",
location as "Location",
project as "Project"
from
gcp_sql_database_instance
where
project = split_part($1, '/', 7)
and self_link = $1;

Dashboards

The query is used in the dashboards: