---
sourceDocument: Brazil Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# BigQuery metadata collector

# BigQuery metadata collector {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
The BigQuery metadata collector provides read-only access to metadata from an external BigQuery account.

The collector harvests metadata for BigQuery datasets, projects, tables, and columns in a BigQuery instance and make it searchable and discoverable in the data catalog. The collector also harvests column-level lineage relationships
between tables and views.

## Metadata cataloged {#bigquery-metadata-collector__section_bvq_vpc_xhc}

The BigQuery collector catalogs the following information.
{#bigquery-metadata-collector__table_y4b_wqc_xhc__entry__2}

| Object | Information cataloged |
|-|-|
| Datasets | ID, name, description, labels (note these are key/value pairs), created date, last modified date, default table expiry, default partition expiry, data location |
| Projects | Name |
| Tables | Name, Description, Created date, Last modified date, Default table expiration, Data location, Labels, Type (Standard, External, Snapshot, Model), Partitioned on field, Clustered by columns for standard and snapshot tables, Partition type (range or time) requires partition filter - Range (Start, end, interval) Time (Partition type (hour, day, month, year), expiration) |
| Columns | Name, Description, Data Type, Is Nullable, Column size |
| View | Name, description, created date, default table expiration, last modified date, data location, default collation, labels, view SQL, clustered by columns for materialized |
[Table 1. Metadata harvested]

{#bigquery-metadata-collector__table_y4b_wqc_xhc}

## Relationships between objects {#bigquery-metadata-collector__section_udv_vpc_xhc}

Catalog pages show relationships between the following data asset types:
{#bigquery-metadata-collector__table_zs4_fsc_xhc__entry__2}

| Data asset page | Relationships |
|-|-|
| Datasets | Tables, Views |
| Projects | Dataset |
| Tables | Column, Labels |
| Columns | Table, View |
| Views | Column |
| Label Value | Table, View, Project, Dataset |
[Table 2. Relationships between harvested data assets]

{#bigquery-metadata-collector__table_zs4_fsc_xhc}

## Lineage for BigQuery {#bigquery-metadata-collector__section_m2h_nsc_xhc}

The following lineage information is collected by the BigQuery collector.
{#bigquery-metadata-collector__table_ncz_psc_xhc__entry__2}

| Object | Lineage available |
|-|-|
| View Column | The collector identifies the associated column in an upstream view or table: * Where the data is sourced from * That sort the rows via ORDER BY * That filter the rows via WHERE/HAVING * That aggregate the rows via GROUP BY {#bigquery-metadata-collector__ul_svw_rsc_xhc} |
[Table 3. Object lineage availability]

{#bigquery-metadata-collector__table_ncz_psc_xhc}
* **[Prepare to run the BigQuery collector](https://www.servicenow.com/docs/9tjcGgMx5clv9g0cbgNJyQ)**   
  Create a service account and configure authentication before running the collector.
* **[Create a BigQuery metadata collector](https://www.servicenow.com/docs/bfGYSVPBWQm3y7GxnG9UQw)**   
  Create a collector to import metadata from BigQuery.