If I set a Snowflake resource query to run manually (i.e. not every time the page loads), will Retool save the previous query's data in my components/wherever the query's output is displayed? I am trying to strategically cut compute costs down for Snowflake where I have data that isn't updated frequently (but the page is frequently loaded)
New to both Retool and Snowflake, so apologies if this answer is obvious somewhere.
Thanks
Hi @ruston,
Thanks for reaching out!
Reloading the page will reset the query state. I recommend looking into two features:
Local storage - depending on the sensitivity of your data, you might consider storing the query response in your browser's local storage. This would persist for some amount of time, even with page reloads: The localStorage object | Retool Docs
Query caching - it sounds like this would also be a good feature for your use case. With query caching, you can temporarily store the results of the query, so that you don't have to make another call to your database: Query caching | Retool Docs