BigQuery

Overview

Mitzu connects to Google BigQuery using an IAM service account with the proper permissions to access your data. To connect Mitzu to Google BigQuery, you must first create the service account and then configure its credentials in Mitzu.

Supported data types

Mitzu will map the types of the data warehouse based on the following table:

Mitzu type	Data warehouse type
String	STRING
Number	FLOAT64, INT64 with alias INT, SMALLINT, INTEGER, BIGINT, TINYINT, BYTEINT
Boolean	BOOL
Datetime	DATE, DATETIME, TIME, TIMESTAMP
Map	JSON
Struct	STRUCT
Array	ARRAY

info

All unrecognized types will be handled as strings.

Create a Service Account

You need to grant Mitzu four permissions from your Google Cloud console so that we can access your BigQuery data.

1. In your GCP console, create a Service account.
   
   
2. Add four roles to this account:
   

• BigQuery User
• BigQuery Data Viewer
• BigQuery Job User
• BigQuery Read Session User

3. Click Done\
   
4. Create a BigQuery JSON key by clicking the Manage Keys button.\
   
   
5. Save the key in a secure location.

Set the credentials in Mitzu

Set the BigQuery project ID, and then either copy the credentials or upload the credentials JSON file from Google BigQuery.

You can configure the connection query parameters. To do so, click on theAdvanced settings section and enter your parameters into theURL Query Params textbox. You must write each parameter in a new line in the <parameter name>=<parameter value> format.

Click the Test connection button to check if Mitzu can connect to your data warehouse using the entered values.

warning

Mitzu will try to connect to your data warehouse and execute a SELECT 1;command. You may need to grant further permission Mitzu to see and query your data tables.

To save the settings, click the Test connection & Save button.

Next steps

Once the connection is tested an saved the event end dimension tables can be configured. Please follow the setting up event tables guide.