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

Plugins Mods Docs Home

steampipe plugin install gcpsteampipe plugin install gcp

gcp_alloydb_cluster gcp_alloydb_instance gcp_apikeys_key gcp_app_engine_application gcp_artifact_registry_repository gcp_audit_policy gcp_bigquery_dataset gcp_bigquery_job gcp_bigquery_table gcp_bigtable_instance gcp_billing_account gcp_billing_budget gcp_cloud_asset gcp_cloud_identity_group gcp_cloud_identity_group_membership gcp_cloud_run_service gcp_cloudfunctions_function gcp_composer_environment gcp_compute_address gcp_compute_autoscaler gcp_compute_backend_bucket gcp_compute_backend_service gcp_compute_disk gcp_compute_disk_metric_read_ops gcp_compute_disk_metric_read_ops_daily gcp_compute_disk_metric_read_ops_hourly gcp_compute_disk_metric_write_ops gcp_compute_disk_metric_write_ops_daily gcp_compute_disk_metric_write_ops_hourly gcp_compute_firewall gcp_compute_forwarding_rule gcp_compute_global_address gcp_compute_global_forwarding_rule gcp_compute_ha_vpn_gateway gcp_compute_image gcp_compute_instance gcp_compute_instance_group gcp_compute_instance_metric_cpu_utilization gcp_compute_instance_metric_cpu_utilization_daily gcp_compute_instance_metric_cpu_utilization_hourly gcp_compute_instance_template gcp_compute_machine_image gcp_compute_machine_type gcp_compute_network gcp_compute_node_group gcp_compute_node_template gcp_compute_project_metadata gcp_compute_region gcp_compute_resource_policy gcp_compute_route gcp_compute_router gcp_compute_snapshot gcp_compute_ssl_policy gcp_compute_subnetwork gcp_compute_target_https_proxy gcp_compute_target_pool gcp_compute_target_ssl_proxy gcp_compute_target_vpn_gateway gcp_compute_url_map gcp_compute_vpn_tunnel gcp_compute_zone gcp_dataplex_asset gcp_dataplex_lake gcp_dataplex_task gcp_dataplex_zone gcp_dataproc_cluster gcp_dataproc_metastore_service gcp_dns_managed_zone gcp_dns_policy gcp_dns_record_set gcp_iam_policy gcp_iam_role gcp_kms_key gcp_kms_key_ring gcp_kms_key_version gcp_kubernetes_cluster gcp_kubernetes_node_pool gcp_logging_bucket gcp_logging_exclusion gcp_logging_log_entry gcp_logging_metric gcp_logging_sink gcp_monitoring_alert_policy gcp_monitoring_group gcp_monitoring_notification_channel gcp_organization gcp_project gcp_project_organization_policy gcp_project_service gcp_pubsub_snapshot gcp_pubsub_subscription gcp_pubsub_topic gcp_redis_instance gcp_secret_manager_secret gcp_service_account gcp_service_account_key gcp_sql_backup gcp_sql_database gcp_sql_database_instance gcp_sql_database_instance_metric_connections gcp_sql_database_instance_metric_connections_daily gcp_sql_database_instance_metric_connections_hourly gcp_sql_database_instance_metric_cpu_utilization gcp_sql_database_instance_metric_cpu_utilization_daily gcp_sql_database_instance_metric_cpu_utilization_hourly gcp_storage_bucket gcp_storage_object gcp_tag_binding gcp_vertex_ai_endpoint gcp_vertex_ai_model gcp_vertex_ai_notebook_runtime_template gcp_vertex_ai_notebook_runtime_template,md gcp_vpc_access_connector

Table: gcp_tag_binding - Query GCP Tag Bindings using SQL

Google Cloud's Tag Manager allows users to attach metadata to GCP resources in the form of tags. Tags are key-value pairs that help in organizing and managing resources, such as VM instances, storage buckets, and networks. Tag bindings are the association between a tag and a resource, which allows users to filter and manage resources based on their metadata.

Examples

Basic info

Explore which resources are tagged within your Google Cloud Platform, gaining insights into the associated tags and resource types. This can be particularly useful for managing and organizing your resources.

select
  name,
  parent,
  tag_value,
  title
from
  gcp_tag_binding
where
  parent = '//cloudresourcemanager.googleapis.com/projects/your-project-id';

select
  name,
  parent,
  tag_value,
  title
from
  gcp_tag_binding
where
  parent = '//cloudresourcemanager.googleapis.com/projects/your-project-id';

Schema for gcp_tag_binding

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
name	text		The name of the TagBinding. This is a string of the form: `tagBindings/{full-resource-name}/{tag-value-name}`.
parent	text	=	The full resource name of the resource the TagValue is bound to.
project	text	=, !=, ~~, ~~, !~~, !~~	The GCP Project in which the resource is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tag_value	text		The TagValue of the TagBinding. Must be of the form `tagValues/456`.
tag_value_namespaced_name	text		The namespaced name for the TagValue of the TagBinding.
title	text		Title of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- gcp

You can pass the configuration to the command with the --config argument:

steampipe_export_gcp --config '<your_config>' gcp_tag_binding