Writing to destinations

The requirements for managing the destinations are similar to those for connecting to internal datasets described in Chapter 4, Sourcing the Data. Managing the destinations falls into three categories:

• Writing to local files
• Writing to databases
• Custom connection tools from Alteryx Gallery

Managing these three categories on a local machine is relatively simple, but should be done in a manner that works for other people or environments (such as your Alteryx Server). In this section, we will look at the default way in which you connect to local files and how we can make that connection process more robust, why those changes fit with our DataOps processes, and how we can leverage these changes for collaboration.

Writing to files

Saving files to a location on your computer is a good way to persist data during a pipeline development. When you do save the file, it is often saved as a full path, such as C:\Users\username\project\output_file...