Error: User Has Neither Fine-Grained Reader nor Masked Get Permission

Issue

The destination fails with the following error:

Access Denied: BigQuery: User has neither fine-grained reader nor masked get permission to get data protected by policy tag.

Environment

Connector: BigQuery

Resolution

To resolve this issue, grant the Fivetran service account either the Data Catalog Fine-Grained Reader role or the BigQuery Masked Reader role. In addition, review any column-level security policies applied to the dataset and adjust or remove them to allow appropriate column access.

For more information on column-level access control and the relevant roles, see BigQuery's column-level security documentation.

Cause

This issue occurs when the BigQuery dataset owner or administrator enables column-level security, and the Fivetran service account lacks the permission required to access protected columns.