Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.


SQL caching in Qlik Sense

Hope someone can help me fault find this one.

I have a SQL database with large volumes of data in it.  I import a load of data into the SQL database from our factory system (OPC PLC & DCS system) / change some of the data and it doesn't appear in my app after re load.  The original / previous data is unchanged.

I am using a simple SQL Select * statement in my load script and the data is clearly there in SQL.

Weirdly the data seems to be there some time after.  I normally make the changes to SQL on an evening and the next day it's there!

Does anyone know if Qlik somehow caches data from SQL?  Is there a setting I can adjust to prevent this in future?

Many thanks

Tags (1)