BigQuery

You can connect the Studio platform to Google BigQuery using the BigQuery Connector.

For more information regarding data connectors, please refer to the data connector user guide.

Note: If you configured your BigQuery connector prior to May 25th, 2022, please visit this guide to upgrade your BigQuery service account.

BigQuery Connector Form

When adding a BigQuery Data Connector you will be presented with a form enabling you to configure your connector.

BigQuery Connector Form.BigQuery Connector Form.

BigQuery Connector Form.

To create a BigQuery Connector, fill the following fields:

FieldDescription
NameAn arbitrary name for your data connector.
DescriptionOptional. An arbitrary description for your data connector.
Project IDYour ProjectID from Google Developer Console. For more details see step 2 of the configuration guide.
Service Account KeyThe JSON file generated from your Service Account in Google Developers Console. For more details see step 8 of the configuration guide.

With the exception of the Description field, all fields are required.

After all required fields are populated correctly, click Confirm to create a new BigQuery connector.

Configuration Guide

Follow these steps to create a service account for your BigQuery data connector:

The Google Developers Console.The Google Developers Console.

The Google Developers Console.

2. Click on the dropdown list to the right of "Google Cloud Platform."

The names and IDs for all the projects you are a member of are displayed.

Copy the ID of the project you wish to connect to, then paste it into the Project ID field.

Google Cloud Platform's Project selection window.Google Cloud Platform's Project selection window.

Google Cloud Platform's Project selection window.

3. Click on the hamburger menu on the top left of the page, and select IAM & Admin >> Service Accounts.
The Service Accounts button.The Service Accounts button.

The Service Accounts button.

4. Click the + CREATE SERVICE ACCOUNT button.
The create service account button.The create service account button.

The create service account button.

5. Input a Service Account Name and Service Account Description.

Enter any arbitrary name and description (e.g., Studio Data Connector, Connection to query data inside Foursquare Studio).

Entering a service account name and description.Entering a service account name and description.

Entering a service account name and description.

6. Grant the new service account BigQuery Data Viewer, BigQuery Job User, and BigQuery Read Session User roles. Skip step 3, then click Done.
Adding the three required service accounts.Adding the three required service accounts.

Adding the three required service accounts.

7. Click on the three dots to the right of the created service account, then select Manage Keys >> Add Key >> Create New Key.
The manage keys button.The manage keys button.

The manage keys button.

8. In the pop-up dialog, choose JSON as the key type, click CREATE.

A .json key will be automatically generated and downloaded to your desktop. Upload this .json key in the Connect to BigQuery Dialog in Foursquare Studio.

Selecting JSON in the pop-up dialog.Selecting JSON in the pop-up dialog.

Selecting JSON in the pop-up dialog.


Sign In