Google BigQuery
Source and destination
-
Go to https://console.cloud.google.com/apis/credentials/serviceaccountkey to create a new service account.
-
Select these BigQuery roles:
- BigQuery Job User
- BigQuery Data Viewer
- BigQuery Metadata Viewer
If you plan on using BigQuery as a destination, you'll also need:
- BigQuery Data Editor
- Select JSON for Key type.
-
Click Create and save the JSON key file.
-
In Polytomic, go to Connections → Add Connection → Google BigQuery.
-
Upload the JSON service account key from step 3 to Polytomic's Service account credentials field.
- Click Save.
Note: if you are trying to write "Record" field types in BigQuery, Polytomic may modify field names in order to comply with BigQuery field naming rules. The following rules apply:
- Only the first 300 characters are used.
- Field names consist of only upper/lowercase letters, numbers, and underscores.
-
,.
,_
.- All other characters are dropped.
Updated about 2 months ago