Bigquery
How to set up the Bigquery connection and additional notes on using it
With Codatum, you can connect, query, and manage data of Bigquery.
How to Set Up
Steps in BigQuery
First, perform the following operations in the BigQuery console:
Generate a service account and service account key
Grant the following roles or permissions to the target project:
Role:
BigQuery Job User
or the following permissions:bigquery.jobs.create
Save the target
Project ID
as it is necessary for the steps in Codatum.
Grant the following roles or permissions to the target datasets:
Role:
BigQuery Data Viewer
or the following permissions:bigquery.tables.getData
bigquery.datasets.get
bigquery.tables.get
bigquery.tables.list
(Optional) Grant the following permissions to the target project if you want to avoid entering the Project ID each time you sync dataset table information
resourcemanager.projects.get
Steps in Codatum
Finally, create Connection in Codatum.
In the Connection list, select
New connection
Enter a Connection name as the
Display Name
Select the Access level
Upload the service account key using
File upload
Enter the Project ID
Use the
Project ID
you saved in the steps above.
Add datasets to the Sync target
Use INFORMATION_SCHEMA for Searching
If you grant the bigquery.admin
permission to the target project, you can utilize INFORMATION_SCHEMA tables to search any tables in non-synced datasets.
Last updated