Alert: Grant Increased BigQuery Table Permissions
Issue
My destination setup tests are successful. However, the following alert appears:
Grant increased BigQuery table permissions
Environment
Resolution
Our service account doesn't have the required permissions on the BigQuery dataset.
To fix the issue, grant the Fivetran service account bigQuery.dataOwner permission for the tables.
Cause
Fivetran can't write data to tables in your destination if:
- A different user created the table
- Fivetran doesn’t have permission to create a table in your destination
- Fivetran doesn’t have permission to write data to the table or to change the column types