Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Run and Cache Workflow.

Hello Team,

 

When we do run and cache workflow it remain in the cache memory for only the time the Alteryx designer or that workflow is open.

 

Advantage: We dont need to wait for the data to load in input data tool and the result is validated properly.

 

Disadvantage: Loss of time and money when the Alteryx Designer is closed automatically or mistaken.

 

Expectation:

 

Can we provide a token Expiry for 12 to 24 hrs so the precious time and money is not wasted.

This will be very useful when we are working on billions of Data.

4 Comments
TheOC
15 - Aurora

Hi @rohit782192 

I think this is an excellent idea. Just a bit of context for how the cache and run workflow functionality works:
https://community.alteryx.com/t5/Engine-Works/Just-take-the-Cache-and-Run-Caching-in-2018-3/ba-p/306...

This blog explains it perfectly, but effectively a yxdb file is dropped out at the point of caching. This is saved to the temp directory, which is stored within ram. This explains why the data can be imported so quickly. One limitation of this is that the temp directory will be cleared in the case of a shutdown of the machine, or closing of Alteryx Designer.

I would recommend, as a manual solution, for now, creating an export of the data using a manual yxdb file to a location on your drive. This typically will not import as quickly as the cached data from the temp directory, as that is stored within RAM, however it may provide the functionality you require.

 

As an extension of the idea - it would be cool if caching the workflow could allow for this location to be set (either a temp directory or a location on the drive).


Cheers,
TheOC

rohit782192
10 - Fireball
I echo with @TheOC
AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
rohit782192
10 - Fireball

Please vote if you like my idea