Create a connection in Anaplan Data Orchestrator to import data from Snowflake. Then use the connection to extract data and create a source dataset.
Network policy restrictions
Before you connect Data Orchestrator with Snowflake, confirm that your network policy allows access from Anaplan public IPs to access the Snowflake account. If the Java Database Connectivity (JDBC) access to Snowflake uses an intermediary environment, such as Azure Blob, this must also be accessible.
For more information about network policies, see the Snowflake documentation .
Create a dedicated database user
We recommend that you create a dedicated read-only user with access to the relevant schemas. This step is optional but highly recommended to allow for better permission control and auditing.
Alternatively, you can use Data Orchestrator with an existing user in your database.
To create a dedicated database user, run these commands against your Snowflake database:
-- set variables (these need to be uppercase)
SET ADO_ROLE = 'ADO_ROLE';
SET ADO_USERNAME = 'ADO_USER';
-- set user password
SET ADO_PASSWORD = '-password-';
BEGIN;
-- create ADO role
CREATE ROLE IF NOT EXISTS $ADO_ROLE;
-- create ADO user
CREATE USER IF NOT EXISTS $ADO_USERNAME
PASSWORD = $ADO_PASSWORD
DEFAULT_ROLE = $ADO_ROLE
DEFAULT_WAREHOUSE= $ADO_WAREHOUSE;
-- grant ADO schema access
GRANT OWNERSHIP ON SCHEMA $ADO_SCHEMA TO ROLE $ADO_ROLE;
COMMIT;
Create a connection with 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:
- Select Data Orchestrator from the top-left navigation menu.
- Select Connections from the left-side panel, then select Create connection.
- Select Snowflake and then select Next.
If you can't find the connector, enter a search term in the Find... field. - On the Connection details page, enter a Name and Description for your connection, then select Next.
- On the Connection credentials page, enter your Snowflake credentials and select Next.
See the table below in the Connection credential fields section for more information about the fields. - After the connection test is complete, select Done.
Connection credential fields
This table provides more information fields that display on the Connection credentials page. Use the scroll bar below the table to view the complete table.
Connection credentials fields | Description |
Auth Type | Select an authentication type:
|
Username | The user name required to authenticate. Must be a string with a maximum length of 255 characters. Example: ANAPLAN_USER |
Host | The host domain of the Snowflake instance. It must include the account, region, cloud environment, and end with snowflakecomputing.com . You can get the host name from the browser URL when you are logged in to Snowflake. You can also get the full host URL from the activation email. Example: accountname.us-east-2.aws.snowflakecomputing.com |
Role | The role created for Data Orchestrator to access Snowflake. It must be a string with a maximum length of 255 characters. Example: ADO_ROLE |
Warehouse | The warehouse created for Data Orchestrator to synchronize data into. It must start with a letter or underscore and can contain letters, digits, underscores, and dollar signs. The maximum length is 255 characters. Example: PLANNING_WAREHOUSE |
Database | The database created for Data Orchestrator to synchronize data into. It must start with a letter or underscore and can contain letters, digits, underscores, and dollar signs. The maximum length is 255 characters. Example: PLANNING_DATABASE |
Schema | The schema whose tables this replication is targeting. If no schema is specified, all tables with permissions will be presented regardless of their schema. It must start with a letter or underscore and can contain letters, digits, underscores, and dollar signs. The maximum length is 255 characters. |
Extract data from a Snowflake connection
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:
- Select Data Orchestrator from the top-left navigation menu.
- Select Source data from the left-side panel.
- Select Add data > From connection.
- On the Dataset details page, 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.
- On the Choose an upload type page, enter these details and select Next:
- 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.
- Select the columns to import.
- Select the Load type:
- Select Create in the confirmation dialog.
For more information, see this community article: How to test the ADO Snowflake connector