GCP discovery › Available cloud discovery patterns › Discovery patterns used by ITOM Visibility › ITOM Visibility › IT Operations Management
GCP BigQuery pattern-based discovery
Discovery and Service Mapping Patterns finds GCP BigQuery datasets and tables on your cloud environment. Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.
Pattern-based discovery and mapping requirements
Verify the GCP discovery prerequisites section in Google Cloud Platform (GCP) Cloud discovery using Patterns.
Data collected by Discovery during horizontal discovery
Discovery populates the data in the CMDB when running the Google Cloud Platform (GCP) - BigQuery DB pattern.
| 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]. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
CI relationships
The Google Cloud Platform (GCP) - BigQuery DB pattern creates these relationships to support GCP BigQuery discovery.
| 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 Tag discovery
The Google Cloud Platform (GCP) - BigQuery DB pattern collects tags and populates them in the Key Value [cmdb_key_value] table.
| Field | Description |
|---|
| Key [key] | Tag name. |
| Value [value] | Tag value. |
| Configuration item [configuration_item] | References the Cloud DataBase [cmdb_ci_cloud_database] table. |
Parent Topic:Google Cloud Platform (GCP) Cloud discovery using Patterns