Let's Talk About Cache

Question

I have something that I do not know the answer to when it comes to using the Input Tool's "Cache Data" checkbox option.    Does this cache have a time-to-live before it re-runs, or once checked will it never re-pull data?

I found a place in a published workflow that had that cache data checked, and it makes me wonder if this should always be on the checklist to look for before publishing a production workflow (i.e. NEVER PUBLISH with this option checked?)

Seems like it would be a master on/off like there is for browse tools if it never re-pulls data.   Can anyone confirm or tell me why you might want this checked in a published workflow.

dataguyW · Answer

Thanks all.      I think I was thrown me off that the input tool's cache data option was checked.   Now if it just doesn't run on the server that would make sense.   I'll look through those link @ChrisTX

ChrisTX · Answer

@dataguyW none of these articles mention the server or gallery.  Unfortunate.  Looks like we're left to "guess" that cache is disabled on the server, even if the checkbox is checked in an Input Data tool.

Just take the Cache and Run! Caching in 2018.3
https://community.alteryx.com/t5/Engine-Works-Blog/Just-take-the-Cache-and-Run-Caching-in-2018-3/ba-p/306651

What Can't Be Cached?
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/What-Can-t-Be-Cached/ta-p/265828

Tool Mastery | Input Data
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Input-Data/ta-p/36909

Chris

alexnajm · Answer

@dataguyW it is not used on the Gallery from my understanding - it is just for your “session” in Designer Desktop.

@Yoshiro_Fujimori it’s the Cache option that you have in the Input Data tool when running database connections!