topic Re: Working with partitioned data in Connectivity & Data Prep

Working with partitioned data

Anouk — Mon, 17 May 2021 11:40:16 GMT

Hello,

I would like to work with partitioned data but I keep receiving the same error:

Unable to retrieve a fields list from the table Node_data: ERROR [42000] [Qlik][BigQuery] (70) Invalid query: Cannot query over table 'node_activity_dsi.Node_data' without a filter over column(s) 'date' that can be used for partition elimination

I've tried several filters but cannot make it work.

Thank you in advance for your help

Re: Working with partitioned data

Eugene_Sleator — Thu, 27 May 2021 14:41:33 GMT

Do you have the 'require partition filter' set on you BQ table..node_activity_dsi.Node_dat

Re: Working with partitioned data

Anouk — Fri, 28 May 2021 06:56:46 GMT

Yes I do have the require partition filter on the BQ table.

Re: Working with partitioned data

Eugene_Sleator — Thu, 02 Sep 2021 13:16:15 GMT

refer to this

Qlik Sense BigQuery connector: Unable to retrieve a field list from the table Products_View: ERROR[HY000][Qlik][BigQuery](1000) Error interacting with REST API