You can import data from Snowflake to create source datasets in Anaplan Data Orchestrator (ADO). To import data, you need a connection to Snowflake and either a pipeline or a connection extract.

You must first use the Snowflake connector in ADO to create the connection. Then use that connection to either create a pipeline or use a connection extract for data import.

Prerequisites

See the sections below for the requirements needed before you create a Snowflake connection.

Create a connection with Snowflake

Use the Snowflake connector in Data Orchestrator to create a connection.

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. Choose a dataspace from the list.
  3. Select Connections from the left-side panel.
  4. Select Create connection.
  5. Select the Snowflake connector and then select Next.
    If you can't find the connector, enter a search term in the Find... field.
  6. Enter these details on the Connection details screen, and then select Next:
    • Name: Create a name for your connection. The name can contain alphanumeric characters and underscores.
    • Description: Enter a description about your connection.
  7. Enter your Snowflake credentials on the Connection credentials screen, and then select Next.
    For information about the fields on the Connection credentials screen, see Authentication options for Snowflake connections.
  8. After the connection test is complete, select Done.

Import data

You can import data from Snowflake with a pipeline or a connection extract. Use the connection you created to configure the pipeline or connection extract.

Related content