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

[Richard_T]

Google Storage API authentication error when attempting to load all data in the table.

By applying LIMIT to the load statement, the load is successful to a 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 an authentication error:

Processing error: ERROR [HY000] [Microsoft][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions.

Environment

• Qlik Cloud Analytics  
• 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