Question:

Why does BigQuery source connector throw the error “Unable to create a temporary table in BigQuery” when testing the connector?

Answer:

BigQuery roles can be applied at dataset, project, or table level.  When applied at the project level, bigquery.admin provides all needed permissions. 

When applied at the dataset level, the bigquery.jobUser permission is needed to create temp tables.

If project-level permissions are restricted, ensure these roles below are applied at the dataset level:

• bigquery.jobUser
• bigquery.admin
• bigquery.user