For step-by-step setup guidance, see the BigQuery Integration guide.
-
Project ID and Dataset ID: Users must provide a project ID and dataset ID where data will be written.
-
Service Account Permissions: Triple Whale requires you to grant BigQuery editor permission to the
[email protected]service account on the specific dataset you are syncing, in order to create and write to tables in that dataset.-
To grant BigQuery editor permission to the service account, navigate to Share > Manage Permissions
-
Click Add Principal
-
Add
[email protected]as New principal, with the role of BigQuery Data Editor
-