Re-runnning Workflow with Cached Data

[valeriemattas]

Hi All,

Is there a simple way to cache data pulled in from a database to reduce run time while building a workflow?

It would be helpful to not have to re-run the workflow with the same data already pulled in/not querying the database again. 

The only thing I've come up with is limiting record count on the connection input, but that doesn't always help test results with sufficient records. 

Thanks for your help!

[cplewis90 · Accepted solution]

Hello @valeriemattas,

You should be able to right-click on the input tool and choose the option that says cache and run workflow. You can check out this post for more: https://community.alteryx.com/t5/Engine-Works-Blog/Just-take-the-Cache-and-Run-Caching-in-2018-3/ba-...

[valeriemattas]

Perfect! Thanks .@cplewis90