GCP Compute Disk Age ReportGCP Compute Disk DashboardGCP Compute Disk DetailGCP Compute Disk Encryption ReportGCP Compute Instance Age ReportGCP Compute Instance DashboardGCP Compute Instance DetailGCP Compute Instance Group DetailGCP Compute Network DashboardGCP Compute Network DetailGCP Compute Subnetwork DetailGCP IAM Service Account DetailGCP IAM Service Account Key Age ReportGCP KMS Key Age ReportGCP KMS Key DashboardGCP KMS Key DetailGCP Kubernetes Cluster Age ReportGCP Kubernetes Cluster DashboardGCP Kubernetes Cluster DetailGCP Project ReportGCP Pub/Sub Topic DetailGCP SQL Database Instance DashboardGCP SQL Database Instance DetailGCP Storage Bucket Age ReportGCP Storage Bucket DashboardGCP Storage Bucket DetailGCP Storage Bucket Encryption Report
Dashboard: GCP SQL Database Instance Detail
This report answers the following questions:
- How is the instance configured?
- What relationships does the database instance have with other resources?
- What tags are applied?
- What instance is it replicated from?
- What kms key is used for the encryption?
- What CPU utilization of my instance?
- What are the connections using my instance?
This dashboard contains 6 cards, 1 graph, 1 input and 4 tables.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-gcp-insights
Start the Powerpipe server:
steampipe service startpowerpipe server
Open http://localhost:9033 in your browser and select GCP SQL Database Instance Detail dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run gcp_insights.dashboard.sql_database_instance_detail --share
Queries
The dashboard uses the named queries:
- sql_database_instance_backup_enabled
- sql_database_instance_connection
- sql_database_instance_cpu_utilization
- sql_database_instance_data_disk_size
- sql_database_instance_database_version
- sql_database_instance_encryption
- sql_database_instance_encryption_detail
- sql_database_instance_is_public
- sql_database_instance_overview
- sql_database_instance_replication_status
- sql_database_instance_ssl_enabled
- sql_database_instance_tags