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 '[email protected]' 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
​

Oracle Autonomous Data Warehouse

Amazon Redshift

Last modified 5mo ago