topic Re: Connect Snowflake from Qlik Sense cloud Data Connection issue when displaying chart in App Development

Connect Snowflake from Qlik Sense cloud Data Connection issue when displaying chart

rajjul — Wed, 17 Aug 2022 06:26:08 GMT

Connecting from Qlik sense Cloud To Snowflake Cloud (running on Azure).

Normal query works well

Direct Query also works well.

But when try to use mix of Direct Query with Normal it gives error message like this.

Is that normal ? Qlik sense not allowing to do both in the same App.

Any other possibilities to do both in the same App..

Some table need to be updated live (direct query) and some table need to be updated normal (qvd or something else).

Please let me know with example . Thank you in advance

Re: Connect Snowflake from Qlik Sense cloud Data Connection issue when displaying chart

Vinay_B — Mon, 22 Aug 2022 09:49:07 GMT

Hi @rajjul,

It's a known limitation that if DirectQuery(LIVE mode) is used, all other requests are ignored. The error is coming from the engine itself. Currently, DQ and normal query processing cannot be mixed up. The only solution would be not to mix them up, unfortunately.

I have notified our documentation team to add this limitation here and it will be done in a coming few days: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DirectQuery/limitations-direct-query.htm

I hope this helps. Let me know if you have any further concerns.

Vinay

Re: Connect Snowflake from Qlik Sense cloud Data Connection issue when displaying chart

rajjul — Tue, 23 Aug 2022 07:35:46 GMT

Thank you Vinay for reply.

But how I can achieve that ? some other way ? like Direct Discovery ? or something else. If possible Please share with me . Thank you