For large datasets in Alteryx, the key is minimizing memory load and unnecessary processing.

Use in-database tools whenever possible to push operations to the database instead of pulling everything into Alteryx. Reduce data early by filtering and selecting only required fields. Replace multiple tools with multi-field or batch macros to streamline workflows. Also, avoid large joins in-memory, instead optimize joins with indexed fields or pre-aggregated data.

Finally, break workflows into smaller modules and cache intermediate outputs to improve performance and debugging.