Before you begin, make sure you have completed the following:
- Cloud Resource Manager API is enabled on your project.
- BigQuery API is enabled on your project.
- Create a BigQuery dataset.
- A service account and service account keyfile. You can create a keyfile following these instructions.
To set up a BigQuery connection, you need to first set up appropriate service account permissions in Google Cloud Platform.
- Navigate to BigQuery > SQL Workspace and select your dataset.
- In the top right of the console, select SHARING > Permissions.
- Select Add Principals and enter your service account.
- From the Select a role dropdown, choose the following roles:
- BigQuery User (roles/bigquery.user)
- BigQuery Data Editor (roles/bigquery.dataEditor) or BigQuery Data Viewer (roles/bigquery.dataViewer)
Select editor if you will be publishing data back to this connection.
- At the project level, give the service account the following permissions:
- Service Usage Consumer (roles/serviceusage.serviceUsageConsumer).
When adding a connection, you are prompted for specific information for the connection type. Gather the following information before adding the connection.
- Description (optional)
- Key file (Google Service Account Key)
Created in your Google service account, this json blob grants Tamr Cloud permissions to access the BigQuery dataset in your GCP account. See Create and manage service account keys.
You can import BigQuery views as source datasets. When adding your source, enter the name of your view in the Table field.
There are certain limitations when working with BigQuery sources that use the BIGNUMERIC data type. In particular, if the source is a table, then BIGNUMERIC columns must have precision of 38 (the default) or less. BIGNUMERIC columns with larger precision are not supported. If the source is a view, then BIGNUMERIC isn’t supported, even with precision 38 or less. If you have a BIGNUMERIC column in a source, cast it to another numeric type or to STRING. For more information about the BIGNUMERIC data type please see the BigQuery Documentation.
Updated about 1 month ago