---
sourceDocument: Australia IT Operations Management
sourceDocumentLink: https://www.servicenow.com/docs/r/australia/it-operations-management

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# GCP BigQuery

# GCP BigQuery pattern-based discovery {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read
Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI  
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.  

## Summary of GCP BigQuery pattern-based discovery

The GCP BigQuery pattern-based discovery enables ServiceNow customers to discover BigQuery datasets and tables within their Google Cloud Platform (GCP) environment.
It requires the latest Discovery and Service Mapping Patterns application and adherence to GCP discovery prerequisites to effectively populate the Configuration Management Database (CMDB) with accurate resource data.
Show full answer Show less  

## Key Features

* **Discovery Scope:** Identifies GCP BigQuery datasets, tables, cloud service accounts, availability zones, datacenters, and public datasets.
* **Data Population:** The discovery process populates multiple CMDB tables such as Cloud Service Account, Availability Zone, Google Datacenter, Cloud Database (BigQuery datasets), Cloud Public Database (public datasets), Database (BigQuery tables), and Key Value (tags).
* **CI Relationships:** Establishes relationships between discovered Configuration Items (CIs), including hosting, containment, usage, and replication among datacenters, cloud service accounts, datasets, and tables, ensuring comprehensive mapping of BigQuery resources.
* **Tag Collection:** Gathers GCP tags associated with BigQuery datasets and stores them in the Key Value table linked to the respective Cloud Database CIs.

## Practical Benefits for ServiceNow Customers

* Enables automated and accurate discovery of BigQuery resources, ensuring your CMDB reflects the current state of your GCP environment.
* Improves visibility into the relationships between datasets, tables, and underlying cloud infrastructure, aiding impact analysis and change management.
* Facilitates compliance and governance by capturing resource states, operational status, and tagging information.
* Supports streamlined cloud service management by integrating BigQuery data into your broader ServiceNow service mapping and discovery framework.  
Discovery and Service Mapping Patterns finds GCP BigQuery datasets and tables on your cloud environment. Discovering some of these resources might require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.

## Pattern-based discovery and mapping requirements {#gcp-bigquery-db-pattern__section_rpj_fj2_bgc}

Verify the GCP discovery prerequisites section in [Google Cloud Platform (GCP) Cloud discovery using Patterns](https://www.servicenow.com/docs/hH4wPjzyLr0pmFmj6Ib5TA "Discovery and Service Mapping Patterns uses patterns to discover components of the Google Cloud Platform (GCP) deployment during horizontal discovery. Discovering some of these resources might require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.").

## Data collected by Discovery during horizontal discovery {#gcp-bigquery-db-pattern__section_ggp_ql2_bgc}

Discovery populates the data in the CMDB when running the Google Cloud Platform (GCP) - BigQuery DB pattern.  
{#gcp-bigquery-db-pattern__table_ps1_twd_wfc__entry__2}

| Field | Description |
|-|-|
| Account Id \[account_id\] | Name of the project used for the discovery. |
| Object ID \[object_id\] | Name of the project used for the discovery. |
| Datacenter Type \[datacenter_type\] | Datacenter type: Google Datacenter \[cmdb_ci_google_datacenter\]. |
[Table 1. Cloud Service Account \[cmdb_ci_cloud_service_account\]]

{#gcp-bigquery-db-pattern__table_ps1_twd_wfc} {#gcp-bigquery-db-pattern__table_mk4_2yd_wfc__entry__2}

| Field | Description |
|-|-|
| Name \[name\] | Name of the availability zone. |
| Description \[short_description\] | Description of the availability zone. |
| State \[state\] | State of the Availability Zone. Possible values are Available or Terminated. |
[Table 2. Availability Zone \[cmdb_ci_availability_zone\]]

{#gcp-bigquery-db-pattern__table_mk4_2yd_wfc} {#gcp-bigquery-db-pattern__table_vbd_1zd_wfc__entry__2}

| Field | Description |
|-|-|
| Name \[name\] | Datacenter or region name. |
| Region \[region\] | Datacenter or region name. |
| Object ID \[object_id\] | Unique identifier allocated by GCP for this resource. |
| Description \[short_description\] | Datacenter or region description. |
[Table 3. Google Datacenter \[cmdb_ci_google_datacenter\]]

{#gcp-bigquery-db-pattern__table_vbd_1zd_wfc}  
{#gcp-bigquery-db-pattern__table_cloud_database__entry__2}

| Field | Description |
|-|-|
| Name \[name\] | Name of the BigQuery dataset. |
| Object ID \[object_id\] | The fully qualified unique identifier of the dataset in the format projectId:datasetId. |
| Install Status \[install_status\] | Install status of the resource. Default value is Installed. |
| Operational status \[operational_status\] | Operational status of the resource. Default value is Operational. |
| State \[state\] | State of the dataset. |
| Fully qualified domain name \[fqdn\] | Fully qualified domain name (FQDN) for accessing the dataset. |
[Table 4. Cloud DataBase \[cmdb_ci_cloud_database\]]

{#gcp-bigquery-db-pattern__table_cloud_database}  
{#gcp-bigquery-db-pattern__table_cloud_public_database__entry__2}

| Field | Description |
|-|-|
| Name \[name\] | Name of the public BigQuery dataset. |
| Object ID \[object_id\] | The fully qualified unique identifier of the dataset in the format projectId:datasetId. |
| Vendor \[vendor\] | Cloud vendor. Value is set to GCP. |
| Install Status \[install_status\] | Install status of the resource. Default value is Installed. |
| Operational status \[operational_status\] | Operational status of the resource. Default value is Operational. |
| State \[state\] | State of the public dataset. |
| Fully qualified domain name \[fqdn\] | FQDN for accessing the public dataset. |
[Table 5. Cloud Public DataBase \[cmdb_ci_cloud_public_database\]]

{#gcp-bigquery-db-pattern__table_cloud_public_database}  
{#gcp-bigquery-db-pattern__table_database__entry__2}

| Field | Description |
|-|-|
| Name \[name\] | Name of the BigQuery table. |
| Type \[type\] | Database type. Value is set to bigquery. |
| Install Status \[install_status\] | Install status of the resource. Default value is Installed. |
[Table 6. Database \[cmdb_ci_database\]]

{#gcp-bigquery-db-pattern__table_database}

## CI relationships {#gcp-bigquery-db-pattern__section_dc4_ghc_dgc}

The Google Cloud Platform (GCP) - BigQuery DB pattern creates these relationships to support GCP BigQuery discovery.  
{#gcp-bigquery-db-pattern__table_bkg_jhc_dgc__entry__3}

| CI | Relationship | CI |
|-|-|-|
| Google Datacenter \[cmdb_ci_google_datacenter\] | Hosted on::Hosts | Cloud Service Account \[cmdb_ci_cloud_service_account\] |
| Google Datacenter \[cmdb_ci_google_datacenter\] | Contains::Contained by | Availability Zone \[cmdb_ci_availability_zone\] |
| Cloud DataBase \[cmdb_ci_cloud_database\] | Hosted on::Hosts | Cloud Service Account \[cmdb_ci_cloud_service_account\] |
| Cloud Service Account \[cmdb_ci_cloud_service_account\] | Uses::Used by | Cloud Public DataBase \[cmdb_ci_cloud_public_database\] |
| Cloud DataBase \[cmdb_ci_cloud_database\] | Hosted on::Hosts | Google Datacenter \[cmdb_ci_google_datacenter\] |
| Cloud DataBase \[cmdb_ci_cloud_database\] | Replicates to::Replicated by | Google Datacenter \[cmdb_ci_google_datacenter\] |
| Cloud Public DataBase \[cmdb_ci_cloud_public_database\] | Replicates to::Replicated by | Google Datacenter \[cmdb_ci_google_datacenter\] |
| Cloud DataBase \[cmdb_ci_cloud_database\] | Contains::Contained by | Database \[cmdb_ci_database\] |
| Key Value \[cmdb_key_value\] | References | Cloud DataBase \[cmdb_ci_cloud_database\] |
[ ]

{#gcp-bigquery-db-pattern__table_bkg_jhc_dgc}

## GCP Tag discovery {#gcp-bigquery-db-pattern__section_lyw_zhc_dgc}

The Google Cloud Platform (GCP) - BigQuery DB pattern collects tags and populates them in the Key Value \[cmdb_key_value\] table.  
{#gcp-bigquery-db-pattern__table_ojy_vss_5hc__entry__2}

| Field | Description |
|-|-|
| Key \[key\] | Tag name. |
| Value \[value\] | Tag value. |
| Configuration item \[configuration_item\] | References the Cloud DataBase \[cmdb_ci_cloud_database\] table. |
[Table 7. Key Value \[cmdb_key_value\]]

{#gcp-bigquery-db-pattern__table_ojy_vss_5hc}