> ## Documentation Index
> Fetch the complete documentation index at: https://docs.peerdb.io/llms.txt
> Use this file to discover all available pages before exploring further.

# BigQuery Setup Guide

<Warning>
  BigQuery as a **destination** is deprecated and no longer actively maintained. It remains fully functional and no code is currently being removed. For new mirrors, we recommend ClickHouse, ClickHouse Cloud, or Postgres as the destination. Note that BigQuery remains a **supported source**.
</Warning>

1. [Create a dedicated Service Account](https://cloud.google.com/iam/docs/keys-create-delete#iam-service-account-keys-create-console) for PeerDB through Google Cloud Console and specify `BigQuery Data Editor`, `BigQuery Data Viewer`, `BigQuery Job User`, `BigQuery Resource Viewer`

   <Frame caption="Create a dedicated Service Account For PeerDB and grant the necessary permissions">
     <img src="https://mintcdn.com/peerdb/L54DxDXK99_p-wL9/images/setup/bq-peerdb-ui.png?fit=max&auto=format&n=L54DxDXK99_p-wL9&q=85&s=8f6b4d4852b7e2f25f3d76af242bf360" width="1510" height="1234" data-path="images/setup/bq-peerdb-ui.png" />
   </Frame>

2. Add a key to the above created service account

   <Frame caption="Add Key to the Service Account">
     <img src="https://mintcdn.com/peerdb/L54DxDXK99_p-wL9/images/setup/bq-add-key-1.png?fit=max&auto=format&n=L54DxDXK99_p-wL9&q=85&s=848581b8fb9968cf2e0d7ad9e2a5d97e" width="2118" height="1490" data-path="images/setup/bq-add-key-1.png" />
   </Frame>

   <Frame caption="Key Added to the Service Account">
     <img src="https://mintcdn.com/peerdb/L54DxDXK99_p-wL9/images/setup/bq-add-key-2.png?fit=max&auto=format&n=L54DxDXK99_p-wL9&q=85&s=ab351ed15edb842642b172d8fa3ca31f" width="2080" height="1432" data-path="images/setup/bq-add-key-2.png" />
   </Frame>

3. Create a dataset dedicated to PeerDB with the name you prefer.

4. Using this service account key create the peer using PeerDB UI

   <Frame caption="Create BigQuery Peer">
     <img src="https://mintcdn.com/peerdb/L54DxDXK99_p-wL9/images/setup/bq-create-peer.png?fit=max&auto=format&n=L54DxDXK99_p-wL9&q=85&s=5516983514b0641c2521cd258da7d4db" width="1656" height="1174" data-path="images/setup/bq-create-peer.png" />
   </Frame>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.