My destination setup tests are successful, but I have a Grant increased BigQuery table permissions alert on my dashboard.
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.
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