Data load from Google BigQuery fails with "Google Storage API authentication error"

[Richard_T]

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. 

• https://cloud.google.com/bigquery/docs/access-control#bigquery
• https://cloud.google.com/iam/docs/reference/rest/v1/Policy

Internal Investigation ID(s)

• QB-5502