auto_create_subnetworkbigquery_datasets_for_kms_keybigquery_datasets_for_kubernetes_clusterbigquery_tables_for_kms_keycloudfunction_functions_for_iam_service_accountcompute_addresses_for_compute_subnetworkcompute_autoscalers_for_compute_instance_groupcompute_backend_buckets_for_storage_bucketcompute_backend_services_for_compute_instance_groupcompute_backend_services_for_compute_networkcompute_disk_1_year_countcompute_disk_24_hours_countcompute_disk_30_90_days_countcompute_disk_30_days_countcompute_disk_90_365_days_countcompute_disk_age_tablecompute_disk_attached_instancescompute_disk_attached_instances_countcompute_disk_by_creation_monthcompute_disk_by_encryption_typecompute_disk_by_locationcompute_disk_by_projectcompute_disk_by_statecompute_disk_by_typecompute_disk_countcompute_disk_customer_managed_encryptioncompute_disk_customer_supplied_encryptioncompute_disk_encryptioncompute_disk_encryption_statuscompute_disk_encryption_tablecompute_disk_google_managed_encryptioncompute_disk_inputcompute_disk_overviewcompute_disk_read_throughputcompute_disk_statuscompute_disk_storagecompute_disk_storage_by_creation_monthcompute_disk_storage_by_encryption_typecompute_disk_storage_by_locationcompute_disk_storage_by_projectcompute_disk_storage_by_statecompute_disk_storage_by_typecompute_disk_storage_totalcompute_disk_tagscompute_disk_top_10_read_ops_avgcompute_disk_top_10_write_ops_avgcompute_disk_typecompute_disk_unattachedcompute_disk_unattached_countcompute_disk_write_throughputcompute_disks_for_compute_instancecompute_disks_for_kms_keycompute_firewalls_for_compute_instancecompute_firewalls_for_compute_instance_groupcompute_firewalls_for_compute_networkcompute_firewalls_for_kubernetes_clustercompute_forwarding_rules_for_compute_networkcompute_forwarding_rules_for_compute_subnetworkcompute_images_for_kms_keycompute_instance_1_year_countcompute_instance_24_hours_countcompute_instance_30_90_days_countcompute_instance_30_days_countcompute_instance_90_365_days_countcompute_instance_age_tablecompute_instance_attached_diskscompute_instance_by_cpu_platformcompute_instance_by_cpu_utilization_categorycompute_instance_by_creation_monthcompute_instance_by_locationcompute_instance_by_projectcompute_instance_by_public_ipcompute_instance_by_statecompute_instance_by_typecompute_instance_confidential_vm_servicecompute_instance_confidential_vm_service_disabled_countcompute_instance_confidential_vm_service_statuscompute_instance_countcompute_instance_deletion_protectioncompute_instance_deletion_protection_disabled_countcompute_instance_deletion_protection_statuscompute_instance_firewall_detailcompute_instance_group_attached_instancescompute_instance_group_inputcompute_instance_group_network_detailcompute_instance_group_overviewcompute_instance_group_sizecompute_instance_groups_for_compute_instancecompute_instance_groups_for_compute_subnetworkcompute_instance_groups_for_kubernetes_clustercompute_instance_inputcompute_instance_network_interfacescompute_instance_overviewcompute_instance_public_accesscompute_instance_shielded_vmcompute_instance_shielded_vm_statuscompute_instance_statuscompute_instance_tagscompute_instance_templates_for_compute_subnetworkcompute_instance_templates_for_iam_service_accountcompute_instance_typecompute_instance_with_public_ip_address_countcompute_instances_for_compute_diskcompute_instances_for_compute_instance_groupcompute_instances_for_compute_networkcompute_instances_for_compute_subnetworkcompute_instances_for_iam_service_accountcompute_instances_for_kubernetes_clustercompute_network_by_creation_modecompute_network_by_projectcompute_network_by_routing_modecompute_network_countcompute_network_default_countcompute_network_default_statuscompute_network_inputcompute_network_is_defaultcompute_network_mtucompute_network_no_subnet_countcompute_network_overviewcompute_network_peeringcompute_network_routing_modecompute_network_subnetcompute_network_subnet_countcompute_network_subnet_statuscompute_network_total_mtucompute_networks_for_compute_instancecompute_networks_for_compute_instance_groupcompute_networks_for_compute_subnetworkcompute_networks_for_kubernetes_clustercompute_networks_for_sql_database_instancecompute_resource_policies_for_compute_diskcompute_routers_for_compute_networkcompute_shielded_vm_disabled_countcompute_snapshots_for_kms_keycompute_subnets_for_compute_instancecompute_subnets_for_compute_instance_groupcompute_subnets_for_kubernetes_clustercompute_subnetwork_cidr_rangecompute_subnetwork_flow_logscompute_subnetwork_inputcompute_subnetwork_is_defaultcompute_subnetwork_networkcompute_subnetwork_overviewcompute_subnetwork_purposecompute_subnetworks_for_compute_networkcompute_top10_cpu_past_weekcompute_vpn_gateways_for_compute_networkdns_policies_for_compute_networkiam_member_roles_for_iam_service_accountiam_policies_for_iam_service_accountiam_roles_for_iam_service_accountiam_roles_for_pubsub_topiciam_service_account_defaultiam_service_account_enablediam_service_account_inputiam_service_account_keys_for_iam_service_accountiam_service_accounts_for_compute_instanceiam_storage_account_keysiam_storage_account_overviewkms_key_1_year_countkms_key_24_hours_countkms_key_30_90_days_countkms_key_30_days_countkms_key_90_365_days_countkms_key_age_tablekms_key_algorithmkms_key_by_creation_monthkms_key_by_locationkms_key_by_projectkms_key_countkms_key_key_ring_namekms_key_name_inputkms_key_name_overviewkms_key_name_tagskms_key_protection_levelkms_key_purposekms_key_rings_for_kms_keykms_key_rotation_periodkms_key_rotation_statuskms_keys_for_compute_diskkms_keys_for_kubernetes_clusterkms_keys_for_pubsub_topickms_keys_for_sql_database_instancekms_keys_for_storage_bucketkms_rotation_disabled_countkubernetes_cluster_1_year_countkubernetes_cluster_24_hours_countkubernetes_cluster_30_90_days_countkubernetes_cluster_30_days_countkubernetes_cluster_90_365_days_countkubernetes_cluster_addons_configkubernetes_cluster_age_tablekubernetes_cluster_auto_repair_disabledkubernetes_cluster_auto_repair_disabled_countkubernetes_cluster_auto_repair_statuskubernetes_cluster_autopilot_enabledkubernetes_cluster_by_creation_monthkubernetes_cluster_by_locationkubernetes_cluster_by_projectkubernetes_cluster_by_statekubernetes_cluster_countkubernetes_cluster_database_encryptionkubernetes_cluster_database_encryption_countkubernetes_cluster_degradedkubernetes_cluster_degraded_countkubernetes_cluster_encryption_statuskubernetes_cluster_inputkubernetes_cluster_ip_allocation_policykubernetes_cluster_lmkubernetes_cluster_network_configkubernetes_cluster_nodekubernetes_cluster_node_countkubernetes_cluster_node_detailkubernetes_cluster_notification_configkubernetes_cluster_overviewkubernetes_cluster_private_cluster_configkubernetes_cluster_shielded_nodes_disabledkubernetes_cluster_shielded_nodes_disabled_countkubernetes_cluster_shielded_nodes_statuskubernetes_cluster_statuskubernetes_cluster_tagskubernetes_clusters_for_compute_instance_groupkubernetes_clusters_for_compute_networkkubernetes_clusters_for_compute_subnetworkkubernetes_clusters_for_kms_keykubernetes_clusters_for_pubsub_topickubernetes_node_pools_for_kubernetes_clusterlogging_buckets_for_storage_bucketnetwork_firewall_rules_countprimary_sql_database_instances_for_sql_database_instanceproject_countproject_tablepubsub_snapshots_for_pubsub_topicpubsub_subscriptions_for_iam_service_accountpubsub_subscriptions_for_pubsub_topicpubsub_topic_encryptionpubsub_topic_encryption_detailspubsub_topic_inputpubsub_topic_labeledpubsub_topic_overviewpubsub_topic_subscription_detailspubsub_topic_tagspubsub_topics_for_kms_keypubsub_topics_for_kubernetes_clusterreplica_sql_database_instances_for_sql_database_instanceservice_account_key_1_year_countservice_account_key_24_hours_countservice_account_key_30_90_days_countservice_account_key_30_days_countservice_account_key_90_365_days_countservice_account_key_age_tableservice_account_key_countsource_compute_disks_for_compute_disksource_compute_firewalls_for_iam_service_accountsource_compute_images_for_compute_disksource_compute_snapshots_for_compute_disksql_backups_for_kms_keysql_backups_for_sql_database_instancesql_database_instance_backup_enabledsql_database_instance_backup_enabled_countsql_database_instance_backup_statussql_database_instance_by_database_versionsql_database_instance_by_locationsql_database_instance_by_projectsql_database_instance_by_replicasql_database_instance_by_statesql_database_instance_connectionsql_database_instance_countsql_database_instance_cpu_utilizationsql_database_instance_data_disk_sizesql_database_instance_database_versionsql_database_instance_encryptionsql_database_instance_encryption_countsql_database_instance_encryption_detailsql_database_instance_encryption_statussql_database_instance_inputsql_database_instance_is_publicsql_database_instance_overviewsql_database_instance_point_in_time_recovery_enable_countsql_database_instance_point_in_time_recovery_statussql_database_instance_public_access_countsql_database_instance_public_access_statussql_database_instance_replication_statussql_database_instance_ssl_enabledsql_database_instance_ssl_enabled_countsql_database_instance_tagssql_database_instances_for_compute_networksql_database_instances_for_kms_keysql_database_ssl_statussql_databases_for_sql_database_instancestorage_bucket_1_year_countstorage_bucket_24_hours_countstorage_bucket_30_90_days_countstorage_bucket_30_days_countstorage_bucket_90_365_days_countstorage_bucket_age_tablestorage_bucket_by_creation_monthstorage_bucket_by_encryption_typestorage_bucket_by_locationstorage_bucket_by_projectstorage_bucket_by_public_accessstorage_bucket_by_storage_classstorage_bucket_classstorage_bucket_compute_backend_bucket_detailstorage_bucket_countstorage_bucket_customer_managed_encryptionstorage_bucket_encryption_detailstorage_bucket_encryption_tablestorage_bucket_google_managed_encryptionstorage_bucket_inputstorage_bucket_loggingstorage_bucket_logging_detailstorage_bucket_logging_disabled_countstorage_bucket_logging_statusstorage_bucket_no_retention_policy_countstorage_bucket_overviewstorage_bucket_public_accessstorage_bucket_public_access_countstorage_bucket_retention_policystorage_bucket_retention_policy_statusstorage_bucket_tags_detailstorage_bucket_uniform_bucket_level_accessstorage_bucket_uniform_bucket_level_access_disabled_countstorage_bucket_uniform_bucket_level_access_statusstorage_bucket_versioning_disabledstorage_bucket_versioning_disabled_countstorage_bucket_versioning_statusstorage_buckets_for_kms_keytarget_compute_disks_for_compute_disktarget_compute_firewalls_for_iam_service_accounttarget_compute_images_for_compute_disktarget_compute_snapshots_for_compute_disk
Query: iam_roles_for_iam_service_account
Usage
powerpipe query gcp_insights.query.iam_roles_for_iam_service_accountSteampipe Tables
SQL
select b ->> 'role' as role_idfrom gcp_iam_policy, jsonb_array_elements(bindings) as b, jsonb_array_elements_text(b -> 'members') as m, split_part(m,'serviceAccount:',2) as member_namewhere m like 'serviceAccount:%' and member_name = split_part($1, '/', 1);