BigQuery

Prerequisites

• Data source allows access to LogicLoop if necessary

• Deployment works for organization and data source

• LogicLoop user account is an admin to be able to create a data source

Setup

Before you begin, you need to make sure you have already done the following in your Google Cloud:

1. Create a service account for BigQuery.

2. Grant BigQuery permission to this service account. The least permission required is BigQuery Data Viewer. You might also need other permissions like BigQuery Job User depending on the query to run.

3. Create a service account key of your service account.

Then you can create your BigQuery data source using your service account key.

First, you need to specify your BigQuery project ID and upload your service account key into JSON Key File. If you want to preview the dataset schema in query source page, you need to check Load Schema option. If your dataset is outside of the US, you need to specify the Processing Location , eg. europe-west1. You can find your region name to use from this document.