Discover a seamless integration process! Learn how to connect BigQuery to Peaka effortlessly for streamlined transactions.

This article guides you through the process of connecting BigQuery to Peaka, allowing you to seamlessly access your BigQuery data within the Peaka platform.


Before you start, you will need the following information from BigQuery.

  • Project ID
  • Parent Project ID (optional)
  • Credentials in JSON format

Follow the steps below to obtain it:

  1. Go to the BigQuery dashboard. You can find your Project ID in the blue squared area.
getting project id view in big query dashboard
  1. Visit the Credentials page.

  2. Select "+Create credentials" and then choose "Service account."

getting crediatials view in big query dashboard
  1. Enter a name for the service account (e.g., "Peaka BigQuery Read Account") and select "Create and Continue."
getting servise account details view in big query dashboard
  1. Ensure the service account has the following permissions:
    • BigQuery Data Editor
    • BigQuery User
getting project id view 2 in big query dashboard
  1. You can skip the optional user access step and select "Done."

  2. Your servise account will be created and click on the service account email.

getting email view in big query dashboard
  1. Click the "Add Key" button and select "Create New Key."
opening new key modal view in big query dashboard
  1. Choose the "JSON" file format and click the "Create" button. This will download a JSON key file that you'll need for the integration.
creating new key in big query dashboard

Connecting BigQuery to Peaka

Now that you have obtained the necessary integration data and credentials, you can connect BigQuery to Peaka using the following steps:

  1. Navigate to the settings page in Peaka.

  2. Click the "Add First Connection" button to initiate the connection process:

  3. In the modal that appears, select "BigQuery" as your connection type.

  4. Enter a name for your connection and upload the credentials JSON file you downloaded in step 9.

fill big query form in peaka
  1. Click "Next" to create your BigQuery connection.

Congratulations! You've successfully connected BigQuery to Peaka. You can now access and manage your BigQuery data seamlessly within the Peaka platform.