Google BigQuery

Google BigQuery Setup

Step 1 - Sign up for GCP

Go to https://console.cloud.google.com/ and sign in with a Google Account

Step 2: Get Google Credits

You will be provided with $300 credit initially and can be extended by Google on a case to case basis

Step 3: Create a BigQuery Project

Create a BigQuery project on Google Console and note the project-id. Click and expand 'Select a Project' and create a new dedicated project for Daton

Create BigQuery Project

Step 4: Enable BigQuery APIs

Enable BigQuery APIs for the project by selecting dashboard on APIs and Services menu

Google APIs and Services

Enable BigQuery API

Note: Daton will only need BigQuery service from the Google Cloud Platform. Other services such as Compute Engine are not required

Step 5: Give Daton Permissions

Grant warehouse edit permissions to Daton service account from GCP ‘IAM’ tab.

Grant 'BigQuery Job User' and 'BigQuery Data Owner' permissions to the '[e-mail]' service account

Permissions to be granted are - 'BigQuery Job User' and 'BigQuery Data Owner'

Permissions for Daton

Permissions for Daton Service Account

Step 6: Configure BigQuery in Daton

Note the BigQuery project-id and provide the same while integrating BigQuery data warehouse on Daton