Connecting a Google BigQuery warehouse#

This guide explains how to connect your Google BigQuery warehouse to Adverity.

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.

Note

After confirmation, the warehouse configuration can only be modified through Adverity Support. Ensure all details are correct before proceeding.

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

Note

For Google BigQuery warehouse connections, service account keys cannot be updated through the user interface. To change project, dataset, service account credentials, or other connection parameters, contact Adverity Support through the Warehouse tab or Adverity Help Center.

Switching warehouse providers#

If you want to use a different warehouse provider instead of your currently connected Google BigQuery warehouse, you must contact Adverity Support. Direct switching between warehouse providers is not available through the user interface.

Troubleshooting#

Connection validation error#

If you receive a connection validation error:

  1. Verify your service account has the required permissions:

    • BigQuery Data Editor

    • BigQuery Job User

    • BigQuery User

  2. Ensure the BigQuery API is enabled in your Google Cloud Platform project.

  3. Verify the JSON key file is valid and not expired.

  4. Check that the selected dataset exists and is accessible.

  5. Contact support if issues persist.