turbot/gcp

steampipe plugin install gcpsteampipe plugin install gcp
gcp_audit_policygcp_bigquery_datasetgcp_bigquery_jobgcp_bigquery_tablegcp_bigtable_instancegcp_cloudfunctions_functiongcp_compute_addressgcp_compute_backend_bucketgcp_compute_backend_servicegcp_compute_diskgcp_compute_disk_metric_read_opsgcp_compute_disk_metric_read_ops_dailygcp_compute_disk_metric_read_ops_hourlygcp_compute_disk_metric_write_opsgcp_compute_disk_metric_write_ops_dailygcp_compute_disk_metric_write_ops_hourlygcp_compute_firewallgcp_compute_forwarding_rulegcp_compute_global_addressgcp_compute_global_forwarding_rulegcp_compute_imagegcp_compute_instancegcp_compute_instance_metric_cpu_utilizationgcp_compute_instance_metric_cpu_utilization_dailygcp_compute_instance_metric_cpu_utilization_hourlygcp_compute_instance_templategcp_compute_machine_typegcp_compute_networkgcp_compute_node_groupgcp_compute_node_templategcp_compute_project_metadatagcp_compute_regiongcp_compute_resource_policygcp_compute_routergcp_compute_snapshotgcp_compute_ssl_policygcp_compute_subnetworkgcp_compute_target_https_proxygcp_compute_target_poolgcp_compute_target_ssl_proxygcp_compute_target_vpn_gatewaygcp_compute_url_mapgcp_compute_vpn_tunnelgcp_compute_zonegcp_dns_managed_zonegcp_dns_policygcp_dns_record_setgcp_iam_policygcp_iam_rolegcp_kms_keygcp_kms_key_ringgcp_logging_bucketgcp_logging_exclusiongcp_logging_metricgcp_logging_sinkgcp_monitoring_alert_policygcp_monitoring_groupgcp_monitoring_notification_channelgcp_organizationgcp_projectgcp_project_organization_policygcp_project_servicegcp_pubsub_snapshotgcp_pubsub_subscriptiongcp_pubsub_topicgcp_service_accountgcp_service_account_keygcp_sql_backupgcp_sql_databasegcp_sql_database_instancegcp_sql_database_instance_metric_connectionsgcp_sql_database_instance_metric_connections_dailygcp_sql_database_instance_metric_connections_hourlygcp_sql_database_instance_metric_cpu_utilizationgcp_sql_database_instance_metric_cpu_utilization_dailygcp_sql_database_instance_metric_cpu_utilization_hourlygcp_storage_bucket

Table: gcp_project_organization_policy

The Organization Policy Service gives you centralized and programmatic control over your organization's cloud resources.

Examples

Basic info

select
id,
version,
update_time
from
gcp_project_organization_policy;

Get organization policy constraints for each policy

select
id,
version,
list_policy ->> 'allValues' as policy_value
from
gcp_project_organization_policy;

.inspect gcp_project_organization_policy

GCP Project Organization Policy

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
boolean_policyjsonbFor boolean Constraints, whether to enforce the Constraint or not.
etagtextAn opaque tag indicating the current version of the Policy, used for concurrency control.
idtextThe name of the Constraint the Policy is configuring.
list_policyjsonbList of values either allowed or disallowed.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
projecttextThe GCP Project in which the resource is located.
restore_defaultjsonbRestores the default behavior of the constraint; independent of Constraint type.
titletextTitle of the resource.
update_timetimestamp without time zoneThe time stamp the Policy was previously updated.
versionbigintVersion of the Policy. Default version is 0.