Symptom:
Google Storage API authentication error when attempting to load all data in the table.
With applying LIMIT to the load statement the load is successful to certain extent.
For example, reload may be successful with LIMIT 10,000, while it fails with LIMIT 100,000 or higher.
The error message refers to authentication error:
Processing error: ERROR [HY000] [Microsoft][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions.
Environment
- SaaS Edition of Qlik Sense
- Qlik Sense Enterprise on Windows
- QlikView
Resolution
"BigQuery Read Session User" IAM role needs to be assigned to the user.
Internal Investigation ID(s)
