BigQuery Integration

Getting Started

1. Correlated requires your Google Cloud Project ID to connect to your data in BigQuery - You can find your Google Cloud project ID on the Google Cloud Console in the Project Info section. If you have multiple Google Cloud projects, you'll need to first select the correct one with the project picker in the top left.

Google Cloud Picker to select the right projectGoogle Cloud Picker to select the right project

Google Cloud Picker to select the right project

Google Cloud Console Project ID locationGoogle Cloud Console Project ID location

Google Cloud Console Project ID location

2. Go to the Integrations page in Correlated and click the purple Connect button on the BigQuery card. Then, input your Google Cloud Project ID and click Next to authorize access.

3. In order to authorize access, you will need to run the commands provided in this step. We request the following permissions:

User Roles: bigquery.user, bigquery.jobUser
Data View Roles: bigquery.dataViewer

Configuring Your Integration

1. Once you've authorized access, you can confirm the connection be ensuring the BigQuery integration card is green. Next, click Edit to configure the integration.

2. Navigate to the Connected Tables tab and click Connect Table to bring over the tables you want to see in Correlated.

📘

Note: This step is required because you need to tell Correlated how to interpret your table schema. You can always come back and add more tables later on!

3. In the new pop-up, you'll need to input the required table details (see below) in order to connect it to Correlated. When you're done, click Add Table.

4. Once the desired tables are added, you can easily choose columns to be added as Dimensions in Correlated. While in the Connected Tables tab, click the gear icon to the right of each table, then Add Dimensions.

5. You'll see a modal that lists all of your available columns. Select the columns you want to import and click Add Dimensions. At this point, you can also choose to customize the Dimension names and descriptions.

📘

Note: Once you've added a column as a dimension, it will no longer be available as an option to add!

6. Lastly, you can navigate over to the Dimensions tab to validate that your table columns were successfully added as Dimensions!