Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
mateoramos1997
Contributor
Contributor

Qliksense integration with data source

Hello, 

I have added my snowflake database as data source, at the begining it pull all the data from the database and tables I selected but then I go ahead and empty my snowflake tables, then I reloaded my qlik sense manually and the information still there, so for some reason is not reloading data from data source even if Im manually doing it, Could you provide some help on this, How can I keep both systems in sync

 

Thanks

4 Replies
nevopotokcloudinary
Contributor III
Contributor III

Hi,

Maybe it relate to Snowflake cache that even after empty your tables Qlik see like there still data in them

 

 

marksouzacosta

Hi @mateoramos1997 ,

Can you please share your load script?

 

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

mateoramos1997
Contributor
Contributor
Author

Hi @marksouzacosta ,

 

I haven't loaded a script, what I did is I created an app and then added a external source, I selected snowflake as source of data, then added the server url,port, username and password and test connection, it worked so I connected it, then it pull the data from the table, but now its not in sync even when I manually reload the app

 

hope this helps

 

marksouzacosta

Even so, Qlik creates for you a Load Script. You can check your Load Script in this tab:

marksouzacosta_0-1741610634456.png

 

I have tried to reproduce what you did using the Data Manager, but I don't see anything unusual. But since I don't know exactly what you have done I'll have to see your Load Script to try to figure that out.

Two other questions:
1. How are you reloading your application?
2. Are you doing a full reload or a partial reload?

 

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com