Skip to main content
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.
  1. Create a dedicated Service Account for PeerDB through Google Cloud Console and specify BigQuery Data Editor, BigQuery Data Viewer, BigQuery Job User, BigQuery Resource Viewer

    Create a dedicated Service Account For PeerDB and grant the necessary permissions

  2. Add a key to the above created service account

    Add Key to the Service Account

    Key Added to the Service Account

  3. Create a dataset dedicated to PeerDB with the name you prefer.
  4. Using this service account key create the peer using PeerDB UI

    Create BigQuery Peer