Google BigQuery managed by Improvado

Note: Google BigQuery managed by Improvado is currently supported only as a Destination. This guide doesn’t cover the DataPrep setup for this Destination.

Description

BigQuery is Google's serverless, highly scalable enterprise data warehouse designed for your data analysts. Improvado can load all data gathered from dozens of available data sources to this storage.

This destination is similar to Google BigQuery, but, in this case, the GBQ instance is created and managed by Improvado.

Setup guide

Follow our setup guide to set up GBQ managed by Improvado.

Create a new GBQ instance via Improvado UI

On the GBQ managed by Improvado connection page, fill in the following fields:

1. 1Enter a name for your Destination connection in the Title.
2. 2 Enter the Email with which we will share the dataset. Show more

3. 3Select the GBQ Dataset Region from the dropdown.
4. 4 Select whether you want to Use load by account for this Destination. Show more

5. 5Click the Continue button.

Now you have access to the created Google Cloud Platform project. This project title has the following pattern: <agency-title> Improvado managed.

The project also contains a GBQ dataset. We've made it easy to identify with a name that follows these guidelines:

• If you're using the default workspace for your destination, the dataset name will remain as improvado.
• If you're using a non-default workspace:
  • If the dataset name from your connection parameters isn't improvado, it will be passed as it is.
  • Otherwise, the dataset name will be passed as <workspace_name>_w<workspace_id>.

You can also find GCS Project ID & GCS Project Name fields in the destination settings page:

6. 6 Select the necessary Use binary strings option from the dropdown. Show more

‍

The GBQ managed by Improvado destination status will become active.

Clustering keys

When creating a new load order to a Google BigQuery managed by Improvado destination, you can select up to 4 clustering keys per table. BigQuery co-locates rows that share the same values in these fields, which makes queries that filter on the clustering keys faster and cheaper.

How to set clustering keys

1. 1 In Destinations → your GBQ managed by Improvado destination → New load, pick the data tables you want to load and continue to step 2.
2. 2 In the Clustering column next to each table, click the cell and pick up to 4 fields.
3. 3 The order you pick fields in matters — BigQuery filters by the first key, then the second, and so on. Metrics are not selectable; clustering only makes sense for dimensions, date keys, and properties.

Changing or removing clustering keys

Clustering keys are fixed once a load order is created. To change them, recreate the load order.

Leaving the Clustering field empty creates the destination table without clustering.

Usage tracking

Monitor daily usage of your Improvado‑managed Google BigQuery account via the dedicated GBQ Usage widget on the Billing Dashboard.