Google BigQuery connector: unable to extract data from a large data set

[Joseph_Musekura]

When extracting data from a large data set using Google BigQuery connector, the following error occurs

"ERROR [HT00][Qlik](BigQuery) (100) Error interacting with REST API Response too large to return, consider specifying a destination table in your job configuration ......"

Environment

• Qlik Sense Enterprise
• QlikView

Resolution

Known issues QB-6892 and QB-6533

Use a new version QvODBCConnectorPackage ver 6.149 and/or for previous QvODBC versions (ex ODBC version 6.49.1 built-in your Qlik Sense June 2020SR6 and above),  add the following in "advanced options"

If in advanced mode 'Standard SQL' is used  then add:

• name: LargeResultsDataSetId &  value: temp_poc (where "temp_poc" is the the ID of a created dataset for temporary tables)

if in advanced mode 'Legacy SQL' is used then add:

• name: AllowLargeResults & value: true
• name: LargeResultsDataSetId & value: temp_poc (where "temp_poc" is the the ID of a created dataset for temporary tables)

Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support at support.qlik.com with the ID QB-6892 and QB-6533 for reference.

Cause

Product Defect ID: QB-6892 and QB-6533