Destinations

Overview

A Destination is where all data loads end and where your data ends up sitting. These are typically large Data Warehouses and Matillion Data Loader offers users the choice between Snowflake, Amazon Redshift, and Google BigQuery.

The Manage Destinations dialog allows users to save user-defined configurations for their Destinations under unique names that can then be referred to in other parts of Matillion Data Loader. This also means that multiple configurations can be stored for any given Data Warehouse and used accordingly in when creating pipelines.

You can view and manage your destinations from the Manage - Destinations tab.

From here you can view all of your stored destinations. If you do not have any stored passwords, you can create them from here using the Add new destination button.

Refer to the following topics for more information about creating each type of destination:

• Connecting to Snowflake
• Connecting to Amazon Redshift
• Connecting to Google Big Query

The following screenshot shows an example of a stored Snowflake destination.

You can manage the list of destinations by using the dropdown menu or entering text in the Search field to manually locate a destination.

You can edit a stored password by clicking the pencil icon next to it. You can permanently delete a password by clicking the trashcan icon next to it.