---
title: BigQuery Overview
description: "Quick start guide for ingesting BigQuery datasets, lineage, usage, and profiling into DataHub via the UI ingestion workflow."
---

# BigQuery Ingestion Guide: Overview

## What You Will Get Out of This Guide

This guide will help you set up the BigQuery connector through the DataHub UI to begin ingesting metadata into DataHub.

Upon completing this guide, you will have a recurring ingestion pipeline that will extract metadata from BigQuery and load it into DataHub. This will include to following BigQuery asset types:

- [Projects](https://cloud.google.com/bigquery/docs/resource-hierarchy#projects)
- [Datasets](https://cloud.google.com/bigquery/docs/datasets-intro)
- [Tables](https://cloud.google.com/bigquery/docs/tables-intro)
- [Views](https://cloud.google.com/bigquery/docs/views-intro)
- [Materialized Views](https://cloud.google.com/bigquery/docs/materialized-views-intro)
- [External Tables](https://cloud.google.com/bigquery/docs/external-tables) — including source format, URIs, compression, and max bad records as custom properties

This recurring ingestion pipeline will also extract:

- **Usage statistics** to help you understand recent query activity
- **Table-level lineage** (where available) to automatically define interdependencies between datasets, including lineage from external tables to their GCS source paths
- **Table- and column-level profile statistics** to help you understand the shape of the data

:::caution
You will NOT have extracted [Routines](https://cloud.google.com/bigquery/docs/routines), [Search Indexes](https://cloud.google.com/bigquery/docs/search-intro) from BigQuery, as the connector does not support ingesting these assets
:::

## Next Steps

If that all sounds like what you're looking for, navigate to the [next page](setup.md), where we'll talk about prerequisites

## Advanced Guides and Reference

If you're looking to do something more in-depth, want to use CLI instead of the DataHub UI, or just need to look at the reference documentation for this connector, use these links:

- Learn about CLI Ingestion in the [Introduction to Metadata Ingestion](../../../metadata-ingestion/README.md)
- [BigQuery Ingestion Reference Guide](https://docs.datahub.com/docs/generated/ingestion/sources/bigquery/#module-bigquery)
