How to setup Google BigQuery Project

Google BigQuery setup instructions

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

Step 2: You will be provided with a $300 credit initially which can be extended by Google on a case-to-case basis.

Step 3: 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 for the project by selecting the dashboard on the APIs and Services menu.

Google APIs and Services

Enable BigQuery API

Please note that, Daton will only need BigQuery service from the Google Cloud Platform. Other services such as Compute Engine are not required.

Step 5: Give warehouse edit permissions to the Daton service account from GCP ‘IAM’ tab. Give 'BigQuery Job User' and 'BigQuery Data Owner' permissions to '[e-mail]' service account.

Permissions for Daton

Permissions for Daton Service Account

Step 6: Note the BigQuery project id and provide the same while integrating the BigQuery data warehouse on Daton.

Further documentation on the Google Cloud Storage connector can be found here.