Google BigQuery (Edge)

Last updated on Nov 18, 2026

Activate is currently available for Early Access. Please contact your Hevo account executive or the Support team to enable it for your team. Alternatively, request for early access to try out one or more such features.

Google BigQuery is Google Cloud’s fully managed, serverless data warehouse that lets you store and query large volumes of data using SQL. In Activate, BigQuery acts as the Source that your datasets read from before the data is sent to your business applications.

Activate reads your data from BigQuery without modifying the tables your datasets read from. It connects through a Google Cloud service account and runs its BigQuery jobs in the project that you specify. Activate keeps a record of each sync in a dedicated BigQuery dataset named HEVO in the same project. Activate also exports your data to a Google Cloud Storage (GCS) bucket that you own and reads it from there before sending it to your Target.

If your Pipelines already load data into BigQuery, you can use that same project as your Source. Activate then sends the data that your Pipelines have already loaded and your Transformations have already prepared.


Modifying BigQuery Source Configuration

You can modify the configuration of your BigQuery Source after its creation. However, any configuration changes affect all the datasets built on that Source and all the Activations that use those datasets. If a Source shows the Failed status, its credentials are no longer valid, and every Activation that depends on it fails until the credentials are corrected.

Perform the following steps to modify the configuration of your BigQuery Source in Activate:

  1. In the Navigation Bar, click Activate.

  2. On the Activate page, click the Sources tab.

  3. Click the Source you want to modify to open it in the Detailed View.

  4. In the Source Header, click Edit.

    Click Edit

  5. On the <Your Source Name> page, you can do the following:

    Edit the BigQuery Source

    • Specify a new name for your Source, not exceeding 255 characters.

    • In the Connect to BigQuery section, you can update the Project ID, the Data Location, and the GCS bucket.

    • In the Service account section, click the attach ( ) icon in the Service Account Key (JSON) field to upload a different key file. Activate displays the Required Google Cloud setup panel only after you upload a new key file.

  6. Click Test & Save.

  7. In the Need your attention dialog, click Yes, Go Ahead.

Hevo tests the connection with the updated configuration and saves it. A notification is displayed to confirm that the Source has been updated successfully.


Source Considerations

  • A BigQuery Source does not specify a default BigQuery dataset, so a dataset query that names only the table fails with an invalid source query error, which does not mention the missing BigQuery dataset name. Reference each table in the <BIGQUERY_DATASET_NAME>.<TABLE_NAME> format, which Activate resolves in the project that your Source specifies. You can also name the project, using the <PROJECT_ID>.<BIGQUERY_DATASET_NAME>.<TABLE_NAME> format enclosed in backticks. For example, SELECT email FROM `my-project.marketing.customers`.

  • A Table dataset lists only the BigQuery datasets in the location that your Source specifies. The HEVO BigQuery dataset is not listed.


Limitations

  • Activate supports only service account key authentication for BigQuery. You cannot connect using a user account or workload identity federation.

  • A BigQuery Source works with the BigQuery datasets in one location. To send data from BigQuery datasets in another location, create a separate Source for that location.


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Nov-18-2026 2.54 New document.

Tell us what went wrong