Connecting a Google BigQuery warehouse

Prerequisites

Before connecting to Google BigQuery, perform all of the following actions:

• Create a Google Cloud Platform project with BigQuery API enabled.

• Create a service account with appropriate permissions for BigQuery.

• Generate and download a JSON key file for the service account.

• Create a dataset in BigQuery where Adverity will store data.

• Ensure the service account has the following permissions:

  • BigQuery Data Editor

  • BigQuery Job User

  • BigQuery User

Connecting to Google BigQuery

To connect your Google BigQuery warehouse to Adverity, follow these steps:

1. Go to the Administration page.

2. In the secondary menu, from the Other section, select Warehouse.

3. Click Connect your warehouse.

4. Select Google BigQuery from the available options.

5. Upload your Service Account JSON Key:

   Service Account JSON Key

   Upload credentials via JSON Key format. You can find and download this file in the Google Cloud Platform Console. For further details, visit the Google documentation on Creating and Managing Service Account Keys.

6. Click Next after uploading the file.

7. Configure your BigQuery settings:

   Project ID

   This will be automatically extracted from the uploaded JSON file.

   Dataset

   Select the target dataset from the dropdown menu where Adverity will store data.

8. Click Next to proceed to verification.

9. Review all connection details and click Connect.

10. Click Yes, connect to Google BigQuery warehouse in the confirmation dialog.

Managing Google BigQuery warehouse settings

After connecting, you can store data from your datastreams directly in your Google BigQuery warehouse.

From the Warehouse tab of the Administration page, you can:

• View connection status

• Contact Support

Troubleshooting