Alteryx Tool Tutorial – Calgary Loader (Efficiently Write Large Databases to CYDB)

In this Alteryx tutorial, we explore the Calgary Loader tool — a powerful way to write large datasets into a Calgary Database (CYDB) for faster, indexed data access. Learn how to take a massive dataset (e.g., hundreds of millions of rows) and convert it into an indexed Calgary database. Discover why this approach is faster than filtering CSV or YXDB files. Understand each configuration section, from root file paths to index field selection. See how to choose which fields to index for optimized query performance. Watch the data write process in action, creating both .cydb and .cyidx files. This video focuses on the Calgary Loader. The next tutorial will walk through how to use the Calgary Input tool to efficiently read just the subset of data you need — without loading everything. Video can be found here: https://youtu.be/zlnJgUEoxL4 Whether you're building a high-performance workflow or managing huge data archives, this video will help you get the most out of Alteryx’s Calgary tools. — 👍 Like, comment, and subscribe if you found this helpful! 🔁 Watch more Alteryx Tool Tutorials in this series. 💬 Questions or use cases? Drop them in the comments and I’ll cover them in future videos.