community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Alteryx Designer local data storage

Atom

Hi

 

Would anyone be able to tell me how Alteryx Designer stores analytical (not configuration) data locally on the client machine? Database, flat-file, in-memory structures, proprietary file format, etc.? I'm interested in issues related to data set size limits, performance, network connectivity to source, caching, data persistence, in-memory processing, etc.

 

Thanks and take care,

Shayne

Alteryx Certified Partner
Alteryx Certified Partner
How do you want to store data? That's how Alteryx will store it. The YXDB format is proprietary and neatly compressed the file and saves the metadata.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Atom

Thanks

 

Is the YXDB format used to store Alteryx output, or is it also the data structure used for run-time analysis and processing of data from the data sources? That is, if Alteryx is pulling data in from multiple sources, where would that data be stored while it is being processed?

 

Take care,

Shayne

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Alteryx stores data in memory and caches it to temporary files which I believe are yxdb in format but are sized for quick read and writes.
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels