There are three options to connect to Google BigQuery:
- Create a new project
- Edit an existing project connection
- Export data from the Export tab > Schedule run button
Connecting to Google BigQuery when Creating a New Project
1
Click Enrich. The Enrich page is displayed.
2
Click ‘Create project’. The Create a new project window is displayed.
3
Type in a new project name. The project name needs to be unique.
4
Select a use case from the drop-down.
5
Click Create project. The Upload a dataset window appears.
6
Select Google BigQuery.
7
Choose a connection name.
8
Type in the Bucket Name.
9
Upload the service account key JSON.
10
Click Upload. Your data is uploaded.
11
Click Test Connection to make sure the connection is successful. A message is displayed informing you if the connection was successfully created or not. If the test connection failed, then you are unable to create a connection. Before creating a new connection, a Test Connection must be run. If the test failed, or a parameter was changed, the Create button will be disabled, and you need to create a new connection.
12
After the test connection has succeeded, click Create in order to create the connection.