Big Query Connection Error

[binsurancemarketgr]

I have encountered some problems when trying to reload data for some apps. The following error is presented:

(Connector error: ERROR [HY000] [Qlik][BigQuery] (310) Storage API Error: request failed: internal error)

When setting a row limit (50,000) the query and connection seems to run just fine. However, for 60,000 or more rows we get the aforementioned error message.

This error seems to have appeared out of nowhere since all the apps loaded until recently with a count of rows above 1,000,000.

Thank you.

[hudam]

I am getting a similar error

(Connector error: ERROR [HY000] [Qlik][BigQuery] (310) Storage API Error: Error: { code: INTERNAL, message: RECEIVED RST_STREAM with error code 2 })


did you find any answers?

[Chip_Matejowsky · Accepted solution]

Have a look at Qlik KB article Data load from Google BigQuery fails with "Google Storage API authentication error"

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.

Best Regards

[Frank_S · Accepted solution]

Also check this

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Google-BigQuery-Connector-How-to-setup-...