Import data from Snowflake

You need your Snowflake credentials to connect the Snowflake data with Data Orchestrator. View the Snowflake documentation for more information about your credentials.

To create a connection:

1. Select Data Orchestrator from the top-left navigation menu.
2. Select Connections from the left-side panel.
3. Select Create connection.
4. Select Snowflake and then select Next.
   If you can't find the connector, enter a search term in the Find... field.
5. On the Connection details screen, enter these details and select Next:
   • Name: Create a name for your connection. The name can contain alphanumeric characters and underscores.
   • Description: Enter a description about your connection.
6. On the Connection credentials screen, enter your Snowflake credentials and select Next.
   For information about the fields on the Connection credentials screen, see Authentication options for Snowflake connections.
7. After the connection test is complete, select Done.

You can extract data from the Snowflake connection to add source data to Data Orchestrator. The data extract creates a source dataset.

To extract data:

1. Select Data Orchestrator from the top-left navigation menu.
2. Select Source data from the left-side panel.
3. Select Add data > From connection.
4. On the Dataset details screen, enter these details and select Next:
   • Connection: Select the Snowflake connection you want to base the dataset on. 
   • Dataset name: Create a name for the dataset.
   • Description: Enter a description about the dataset.
   • Namespace: Select a namespace. This is the Snowflake schema for the specific database defined for the connection. 
   • Path name: Select a path name. This is the Snowflake table name. 
5. On the Choose an upload type screen, enter these details and select Next:
   1. Select the Load type:
      • Full replace: Completely replaces the current loaded data with the new data.
      • Append: Adds the new data to the end of the current table.
      • Incremental: Takes the data and incrementally updates what was previously loaded.
   2. Select the columns to import.
6. Select Create in the confirmation dialog.