Alteryx Designer local data storage

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

Best Practices

Installation

Documentation

Accepted answers

MarqueeCrew

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.

All comments

MarqueeCrew

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

shaynegw

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

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167