Error: Failed to Check INFORMATION_SCHEMA.JOBS_BY_USER Permission
Issue
The connector fails with the following error:
Access Denied: Table r365-dna-raw:region-us.INFORMATION_SCHEMA.JOBS_BY_USER: User does not have permission to query table r365-dna-raw:region-us.INFORMATION_SCHEMA.JOBS_BY_USER, or perhaps it does not exist.
Environment
Destination: BigQuery
Resolution
Give the query permission to the INFORMATION_SCHEMA.JOBS_BY_USER table.