# Google BigQuery

Integrate, catalog, and govern Google BigQuery assets in Atlan.

## Required permissions

- [Preflight checks for Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/preflight-checks-for-google-bigquery/llms.txt): Each request requires an OAuth 2.0 access token generated via the service account key.

## Setup options

- [Set up Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/set-up-google-bigquery/llms.txt): You must be a Google BigQuery administrator to run these commands. For more information, see Google Cloud's Granting, changing, and revoking access to resources.
- [Set up Workload Identity Federation](https://docs.atlan.com/llms/connectors/google-bigquery/set-up-workload-identity-federation/llms.txt): Configure Workload Identity Federation (WIF) to enable Atlan to authenticate with Google BigQuery without using service account keys.
- [Enable SSO for Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/enable-sso-for-google-bigquery/llms.txt): Credentials are used to obtain an access token from Google's authorization servers for authentication in Atlan.
- [Choose how Atlan connects to Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/choose-how-atlan-connects-to-google-bigquery/llms.txt): Pick the network path and authentication method Atlan uses to reach Google BigQuery - public API endpoint or Private Service Connect, service account key or Workload Identity Federation.
- [Set up authentication for Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/set-up-authentication-for-google-bigquery/llms.txt): Set up the service account Atlan connects to Google BigQuery as, and choose between a service account JSON key and Workload Identity Federation.
- [Set up Google Private Service Connect](https://docs.atlan.com/llms/connectors/google-bigquery/set-up-google-private-service-connect/llms.txt): Keep Atlan's BigQuery API traffic off the public internet with Google Private Service Connect - Atlan builds the private endpoint; you paste one DNS name.
- [Special cases](https://docs.atlan.com/llms/connectors/google-bigquery/special-cases/llms.txt): Google BigQuery special cases - multiple projects, Delta external tables, Data Quality with WIF, per-user SSO, credential rotation, and the Lakehouse integration.

## Crawl and mine

- [Crawl Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/crawl-google-bigquery/llms.txt): Crawl metadata from Google BigQuery to catalog datasets, tables, views, and columns. Extract lineage and asset details after completing prerequisite setup.
- [Mine Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/mine-google-bigquery/llms.txt): Once you have crawled assets from Google BigQuery, you can mine its query history to construct lineage.
- [Manage Google BigQuery tags](https://docs.atlan.com/llms/connectors/google-bigquery/manage-google-bigquery-tags/llms.txt): Atlan imports your Google BigQuery tags and lets you update your Google BigQuery assets with the imported tags. Note that object tagging in Google BigQuery currently requires Enterprise edition or higher.

## Reference

- [How Atlan connects to Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/how-atlan-connects-to-google-bigquery/llms.txt): Understand how Atlan securely connects to your Google BigQuery data warehouse to extract metadata.
- [How BigQuery connectivity works](https://docs.atlan.com/llms/connectors/google-bigquery/how-bigquery-connectivity-works/llms.txt): Learn how Atlan reaches Google BigQuery, why there are no IP addresses to allowlist on the main path, and the four traffic hops that matter.
- [Query redaction for Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/query-redaction/llms.txt): Reference for Redact SQL Text on Google BigQuery crawler and miner workflows: what Atlan redacts, what it preserves, and limitations to plan for.
- [VPC Service Controls & allowlisting](https://docs.atlan.com/llms/connectors/google-bigquery/vpc-service-controls-and-allowlisting/llms.txt): The Google services and VPC Service Controls ingress rules your security team must allow for Atlan to reach Google BigQuery.
- [What does Atlan crawl from Google BigQuery?](https://docs.atlan.com/llms/connectors/google-bigquery/what-does-atlan-crawl-from-google-bigquery/llms.txt): Atlan doesn't run any table scans. Atlan leverages the table preview options from Google BigQuery that enable you to view data for free and without affecting any quotas using the `tabledata.list` API. Hence, table asset previews in Atlan are already cost-optimized. However, this doesn't apply to views and materialized views.
- [BigQuery assets package](https://docs.atlan.com/llms/connectors/google-bigquery/package-reference/llms.txt): Programmatically crawl and manage Google BigQuery assets in Atlan using the Python SDK (pyatlan). Reference for the BigQuery assets package.
- [BigQuery assets app](https://docs.atlan.com/llms/connectors/google-bigquery/google-bigquery-sdk-references-app-reference/llms.txt): Learn how to crawl Google BigQuery assets and publish them to Atlan for discovery.
- [BigQuery miner app](https://docs.atlan.com/llms/connectors/google-bigquery/google-bigquery-sdk-references-app-miner-reference/llms.txt): Learn how to mine query history from BigQuery to generate lineage and usage metrics.

## Troubleshooting

- [Troubleshooting Google BigQuery connectivity](https://docs.atlan.com/llms/connectors/google-bigquery/troubleshooting-google-bigquery-connectivity/llms.txt): Symptom-first troubleshooting for Google BigQuery connectivity - VPC-SC denials, generic connection errors, WIF failures, key rotation, and cross-project permission issues.
- [Routines and Process assets](https://docs.atlan.com/llms/connectors/google-bigquery/routines-and-process-assets/llms.txt): Frequently asked questions about BigQuery routines and their relationships with Process assets for lineage generation