Summary
In this chapter, we have investigated several methods for saving our datasets for future use. We have seen the common methods for managing how to save files to both local destinations and network drives. These methods also included a process for ensuring that the workflow will not error when it is either shared with other people or saved to an Alteryx server.
We also investigated methods for managing database connections and how those connections can be used across different environments. We saw how the different methods of variable management and DNS connections could be used so that different databases can be targeted in different environments. This ability is especially useful when managing separate development and production environments.
Finally, we implemented these principles to save our places dataset to a Snowflake database table. We implemented the DSN connection so that when publishing to our server, a separate destination can be used in production.
The...
