turbot/steampipe-mod-gcp-insights

Query: sql_database_instance_inventory_table

Usage

powerpipe query gcp_insights.query.sql_database_instance_inventory_table

SQL

select
i.name as "Name",
i.create_time as "Create Time",
i.database_version as "Database Version",
i.state as "State",
i.instance_type as "Instance Type",
i.machine_type as "Machine Type",
i.availability_type as "Availability Type",
i.backup_enabled as "Backup Enabled",
i.kms_key_name as "KMS Key Name",
i.labels as "Labels",
i.connection_name as "Connection Name",
p.name as "Project",
i.location as "Location"
from
gcp_sql_database_instance as i,
gcp_project as p
where
p.project_id = i.project
order by
i.name;

Dashboards

The query is used in the dashboards: