Error: Access Denied on Dataset

Issue

Setup tests fail with the following error:

BigQuery Connection: Unable to connect: Access Denied: Dataset <dataset_id>: Permission bigquery.datasets.get denied on dataset <dataset_id>(or it may not exist)

Environment

Connector: BigQuery

Resolution

To resolve this issue, ensure the Fivetran service account has the permission required to access the relevant BigQuery dataset. For more information, see our BigQuery service account permissions documentation.

Cause

This issue occurs when the Fivetran service account associated with your connection doesn't have the permission required to access your dataset.