turbot/gcp_insights

Query: sql_database_instance_replication_status

Usage

powerpipe query gcp_insights.query.sql_database_instance_replication_status

SQL

select
master_instance_name as "Master Instance Name",
replication_type as "Replication Type",
database_replication_enabled as "Database Replication Enabled",
crash_safe_replication_enabled as "Crash Safe Replication Enabled"
from
gcp_sql_database_instance
where
project = split_part($1, '/', 7)
and self_link = $1;

Dashboards

The query is used in the dashboards: