Documentation

Google BigQuery managed by Improvado

Updated on

Mar 18, 2024

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. Enter a name for your Destination connection in the Title.
  2. Enter the Email with which we will share the dataset. {%dropdown-button name="email"%}

{%dropdown-body name="email"%}

The email address and domain must be associated with an active Google Account or Google Apps account.

{%dropdown-end%}

  1. Select the GBQ Dataset Region from the dropdown.
  2. Select whether you want to Use load by account for this Destination. {%dropdown-button name="use-load-by-account"%}

{%dropdown-body name="use-load-by-account"%}

You must enable this field if you want to use a specific account for data load.

{%dropdown-end%}

  1. Click the Continue button.

You will see Google BigQuery managed by Improvado in your Connected destinations with the following error: ```Please connect billing account to your project``` due to the absence of a billing account.

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>```.

Activate your GBQ instance

Add a billing account to the GBQ project:

  1. Open the Billing page in the Google Cloud Platform.
  2. Connect an existing billing account or create a new one using the Cloud Billing Account Guide.
  1. Return to your connected destinations list after a billing account is connected and click the Recheck the connection button.

If the billing account is connected successfully, the GBQ managed by Improvado destination status will become active.

Schema information

Setup guide

Settings

No items found.

Troubleshooting

Troubleshooting guides

Check out troubleshooting guides for
Google BigQuery managed by Improvado
here:

Limits

Frequently asked questions

No items found.
☶ On this page
Description
Related articles
No items found.
No items found.

Questions?

Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.