Setup Instructions for Google BigQuery
This subtopic provides step-by-step instructions to integrate a BigQuery Destination database with Daton, detailing the prerequisites and the integration process.
Setup Instructions for Google BigQuery
This subtopic provides step-by-step instructions to integrate a BigQuery Destination database with Daton, detailing the prerequisites and the integration process.
Set up on BigQuery
Task 1: Sign up for GCP and get Google Credits
- Go to https://console.cloud.google.com/ and sign in with a Google Account.
- You will be provided with a $300 credit initially which can be extended by Google on a case-to-case basis.
Step 2: 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
Task 3: Enable BigQuery APIs
- Enable BigQuery APIs for the project by selecting the dashboard on the APIs and Services menu.
Note: Daton requires only the BigQuery service from the Google Cloud Platform, and other services like Compute Engine are not necessary for its functionality.
Task 4: Grant Daton the Permission
- Grant warehouse edit permissions to Daton service account from GCP ‘IAM’ tab.
.
Grant 'BigQuery Job User' and 'BigQuery Data Owner' permissions to the 'daton-bigquery@daton-210514.iam.gserviceaccount.com' service account.
Task 5: Configure BigQuery in Daton
- Note the BigQuery project ID and provide the same while integrating the BigQuery data warehouse on Daton.