v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins Docs Home

turbot/gcp_insights

0Controls

0Variables

auto_create_subnetwork bigquery_datasets_for_kms_key bigquery_datasets_for_kubernetes_cluster bigquery_tables_for_kms_key cloudfunction_functions_for_iam_service_account compute_addresses_for_compute_subnetwork compute_autoscalers_for_compute_instance_group compute_backend_buckets_for_storage_bucket compute_backend_services_for_compute_instance_group compute_backend_services_for_compute_network compute_disk_1_year_count compute_disk_24_hours_count compute_disk_30_90_days_count compute_disk_30_days_count compute_disk_90_365_days_count compute_disk_age_table compute_disk_attached_instances compute_disk_attached_instances_count compute_disk_by_creation_month compute_disk_by_encryption_type compute_disk_by_location compute_disk_by_project compute_disk_by_state compute_disk_by_type compute_disk_count compute_disk_customer_managed_encryption compute_disk_customer_supplied_encryption compute_disk_encryption compute_disk_encryption_status compute_disk_encryption_table compute_disk_google_managed_encryption compute_disk_input compute_disk_overview compute_disk_read_throughput compute_disk_status compute_disk_storage compute_disk_storage_by_creation_month compute_disk_storage_by_encryption_type compute_disk_storage_by_location compute_disk_storage_by_project compute_disk_storage_by_state compute_disk_storage_by_type compute_disk_storage_total compute_disk_tags compute_disk_top_10_read_ops_avg compute_disk_top_10_write_ops_avg compute_disk_type compute_disk_unattached compute_disk_unattached_count compute_disk_write_throughput compute_disks_for_compute_instance compute_disks_for_kms_key compute_firewalls_for_compute_instance compute_firewalls_for_compute_instance_group compute_firewalls_for_compute_network compute_firewalls_for_kubernetes_cluster compute_forwarding_rules_for_compute_network compute_forwarding_rules_for_compute_subnetwork compute_images_for_kms_key compute_instance_1_year_count compute_instance_24_hours_count compute_instance_30_90_days_count compute_instance_30_days_count compute_instance_90_365_days_count compute_instance_age_table compute_instance_attached_disks compute_instance_by_cpu_platform compute_instance_by_cpu_utilization_category compute_instance_by_creation_month compute_instance_by_location compute_instance_by_project compute_instance_by_public_ip compute_instance_by_state compute_instance_by_type compute_instance_confidential_vm_service compute_instance_confidential_vm_service_disabled_count compute_instance_confidential_vm_service_status compute_instance_count compute_instance_deletion_protection compute_instance_deletion_protection_disabled_count compute_instance_deletion_protection_status compute_instance_firewall_detail compute_instance_group_attached_instances compute_instance_group_input compute_instance_group_network_detail compute_instance_group_overview compute_instance_group_size compute_instance_groups_for_compute_instance compute_instance_groups_for_compute_subnetwork compute_instance_groups_for_kubernetes_cluster compute_instance_input compute_instance_network_interfaces compute_instance_overview compute_instance_public_access compute_instance_shielded_vm compute_instance_shielded_vm_status compute_instance_status compute_instance_tags compute_instance_templates_for_compute_subnetwork compute_instance_templates_for_iam_service_account compute_instance_type compute_instance_with_public_ip_address_count compute_instances_for_compute_disk compute_instances_for_compute_instance_group compute_instances_for_compute_network compute_instances_for_compute_subnetwork compute_instances_for_iam_service_account compute_instances_for_kubernetes_cluster compute_network_by_creation_mode compute_network_by_project compute_network_by_routing_mode compute_network_count compute_network_default_count compute_network_default_status compute_network_input compute_network_is_default compute_network_mtu compute_network_no_subnet_count compute_network_overview compute_network_peering compute_network_routing_mode compute_network_subnet compute_network_subnet_count compute_network_subnet_status compute_network_total_mtu compute_networks_for_compute_instance compute_networks_for_compute_instance_group compute_networks_for_compute_subnetwork compute_networks_for_kubernetes_cluster compute_networks_for_sql_database_instance compute_resource_policies_for_compute_disk compute_routers_for_compute_network compute_shielded_vm_disabled_count compute_snapshots_for_kms_key compute_subnets_for_compute_instance compute_subnets_for_compute_instance_group compute_subnets_for_kubernetes_cluster compute_subnetwork_cidr_range compute_subnetwork_flow_logs compute_subnetwork_input compute_subnetwork_is_default compute_subnetwork_network compute_subnetwork_overview compute_subnetwork_purpose compute_subnetworks_for_compute_network compute_top10_cpu_past_week compute_vpn_gateways_for_compute_network dns_policies_for_compute_network iam_member_roles_for_iam_service_account iam_policies_for_iam_service_account iam_roles_for_iam_service_account iam_roles_for_pubsub_topic iam_service_account_default iam_service_account_enabled iam_service_account_input iam_service_account_keys_for_iam_service_account iam_service_accounts_for_compute_instance iam_storage_account_keys iam_storage_account_overview kms_key_1_year_count kms_key_24_hours_count kms_key_30_90_days_count kms_key_30_days_count kms_key_90_365_days_count kms_key_age_table kms_key_algorithm kms_key_by_creation_month kms_key_by_location kms_key_by_project kms_key_count kms_key_key_ring_name kms_key_name_input kms_key_name_overview kms_key_name_tags kms_key_protection_level kms_key_purpose kms_key_rings_for_kms_key kms_key_rotation_period kms_key_rotation_status kms_keys_for_compute_disk kms_keys_for_kubernetes_cluster kms_keys_for_pubsub_topic kms_keys_for_sql_database_instance kms_keys_for_storage_bucket kms_rotation_disabled_count kubernetes_cluster_1_year_count kubernetes_cluster_24_hours_count kubernetes_cluster_30_90_days_count kubernetes_cluster_30_days_count kubernetes_cluster_90_365_days_count kubernetes_cluster_addons_config kubernetes_cluster_age_table kubernetes_cluster_auto_repair_disabled kubernetes_cluster_auto_repair_disabled_count kubernetes_cluster_auto_repair_status kubernetes_cluster_autopilot_enabled kubernetes_cluster_by_creation_month kubernetes_cluster_by_location kubernetes_cluster_by_project kubernetes_cluster_by_state kubernetes_cluster_count kubernetes_cluster_database_encryption kubernetes_cluster_database_encryption_count kubernetes_cluster_degraded kubernetes_cluster_degraded_count kubernetes_cluster_encryption_status kubernetes_cluster_input kubernetes_cluster_ip_allocation_policy kubernetes_cluster_lm kubernetes_cluster_network_config kubernetes_cluster_node kubernetes_cluster_node_count kubernetes_cluster_node_detail kubernetes_cluster_notification_config kubernetes_cluster_overview kubernetes_cluster_private_cluster_config kubernetes_cluster_shielded_nodes_disabled kubernetes_cluster_shielded_nodes_disabled_count kubernetes_cluster_shielded_nodes_status kubernetes_cluster_status kubernetes_cluster_tags kubernetes_clusters_for_compute_instance_group kubernetes_clusters_for_compute_network kubernetes_clusters_for_compute_subnetwork kubernetes_clusters_for_kms_key kubernetes_clusters_for_pubsub_topic kubernetes_node_pools_for_kubernetes_cluster logging_buckets_for_storage_bucket network_firewall_rules_count primary_sql_database_instances_for_sql_database_instance project_count project_table pubsub_snapshots_for_pubsub_topic pubsub_subscriptions_for_iam_service_account pubsub_subscriptions_for_pubsub_topic pubsub_topic_encryption pubsub_topic_encryption_details pubsub_topic_input pubsub_topic_labeled pubsub_topic_overview pubsub_topic_subscription_details pubsub_topic_tags pubsub_topics_for_kms_key pubsub_topics_for_kubernetes_cluster replica_sql_database_instances_for_sql_database_instance service_account_key_1_year_count service_account_key_24_hours_count service_account_key_30_90_days_count service_account_key_30_days_count service_account_key_90_365_days_count service_account_key_age_table service_account_key_count source_compute_disks_for_compute_disk source_compute_firewalls_for_iam_service_account source_compute_images_for_compute_disk source_compute_snapshots_for_compute_disk sql_backups_for_kms_key sql_backups_for_sql_database_instance sql_database_instance_backup_enabled sql_database_instance_backup_enabled_count sql_database_instance_backup_status sql_database_instance_by_database_version sql_database_instance_by_location sql_database_instance_by_project sql_database_instance_by_replica sql_database_instance_by_state sql_database_instance_connection sql_database_instance_count sql_database_instance_cpu_utilization sql_database_instance_data_disk_size sql_database_instance_database_version sql_database_instance_encryption sql_database_instance_encryption_count sql_database_instance_encryption_detail sql_database_instance_encryption_status sql_database_instance_input sql_database_instance_is_public sql_database_instance_overview sql_database_instance_point_in_time_recovery_enable_count sql_database_instance_point_in_time_recovery_status sql_database_instance_public_access_count sql_database_instance_public_access_status sql_database_instance_replication_status sql_database_instance_ssl_enabled sql_database_instance_ssl_enabled_count sql_database_instance_tags sql_database_instances_for_compute_network sql_database_instances_for_kms_key sql_database_ssl_status sql_databases_for_sql_database_instance storage_bucket_1_year_count storage_bucket_24_hours_count storage_bucket_30_90_days_count storage_bucket_30_days_count storage_bucket_90_365_days_count storage_bucket_age_table storage_bucket_by_creation_month storage_bucket_by_encryption_type storage_bucket_by_location storage_bucket_by_project storage_bucket_by_public_access storage_bucket_by_storage_class storage_bucket_class storage_bucket_compute_backend_bucket_detail storage_bucket_count storage_bucket_customer_managed_encryption storage_bucket_encryption_detail storage_bucket_encryption_table storage_bucket_google_managed_encryption storage_bucket_input storage_bucket_logging storage_bucket_logging_detail storage_bucket_logging_disabled_count storage_bucket_logging_status storage_bucket_no_retention_policy_count storage_bucket_overview storage_bucket_public_access storage_bucket_public_access_count storage_bucket_retention_policy storage_bucket_retention_policy_status storage_bucket_tags_detail storage_bucket_uniform_bucket_level_access storage_bucket_uniform_bucket_level_access_disabled_count storage_bucket_uniform_bucket_level_access_status storage_bucket_versioning_disabled storage_bucket_versioning_disabled_count storage_bucket_versioning_status storage_buckets_for_kms_key target_compute_disks_for_compute_disk target_compute_firewalls_for_iam_service_account target_compute_images_for_compute_disk target_compute_snapshots_for_compute_disk

Query: sql_database_instance_encryption_detail

Usage

powerpipe query gcp_insights.query.sql_database_instance_encryption_detail

Steampipe Tables

gcp_sql_database_instance

GCP plugin

SQL

select
  k.name as "Key Name",
  k.key_ring_name as "Key Ring Name",
  k.primary ->> 'state' as "Key State",
  k.primary ->> 'algorithm' as "Key Algorithm"
from
  gcp_sql_database_instance as d,
  gcp_kms_key as k
where
  d.kms_key_name = concat('projects', split_part(k.self_link,'projects',2))
  and d.self_link = $1

Dashboards

The query is used in the dashboards:

GCP SQL Database Instance Detail