Ultimate

Create a Snowflake source connection in the UI

IMPORTANT
The Snowflake source is available in the sources catalog to users who have purchased Real-Time Customer Data Platform Ultimate.

This tutorial provides steps for creating a Snowflake source connector using the Adobe Experience Platform user interface.

Getting started

This tutorial requires a working understanding of the following components of Experience Platform:

  • Sources: Experience Platform allows data to be ingested from various sources while providing you with the ability to structure, label, and enhance incoming data using Platform services.
  • Sandboxes: Experience Platform provides virtual sandboxes which partition a single Platform instance into separate virtual environments to help develop and evolve digital experience applications.

Gather required credentials

You must provide values for the following credential properties to authenticate your Snowflake source.

Account key authentication
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2
Credential Description
Account An account name uniquely identifies an account within your organization. In this case, you must uniquely identify an account across different Snowflake organizations. To do this, you must prepend your organization name to the account name. For example: orgname-account_name. For more information on account names, read the Snowflake documentation on account identifiers.
Warehouse The Snowflake warehouse manages the query execution process for the application. Each Snowflake warehouse is independent from one another and must be accessed individually when bringing data over to Platform.
Database The Snowflake database contains the data you want to bring the Platform.
Username The username for the Snowflake account.
Password The password for the Snowflake user account.
Role The default access control role to use in the Snowflake session. The role should be an existing one that has already been assigned to the specified user. The default role is PUBLIC.
Connection string The connection string used to connect to your Snowflake instance. The connection string pattern for Snowflake is jdbc:snowflake://{ACCOUNT_NAME}.snowflakecomputing.com/?user={USERNAME}&password={PASSWORD}&db={DATABASE}&warehouse={WAREHOUSE}
Key-pair authentication

To use key-pair authentication, you must generate a 2048-bit RSA key pair and then provide the following values when creating an account for your Snowflake source.

table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2
Credential Description
Account An account name uniquely identifies an account within your organization. In this case, you must uniquely identify an account across different Snowflake organizations. To do this, you must prepend your organization name to the account name. For example: orgname-account_name. For more information on account names, read the Snowflake documentation on account identifiers.
Username The username of your Snowflake account.
Private key The Base64-encoded private key of your Snowflake account. You can generate either encrypted or unencrypted private keys. If you are using an encrypted private key, then you must also provide a private key passphrase when authenticating against Experience Platform.
Private key passphrase The private key passphrase is an additional layer of security that you must use when authenticating with an encrypted private key. You are not required to provide the passphrase if you are using an unencrypted private key.
Database The Snowflake database that contains the data you want to ingest to Experience Platform.
Warehouse The Snowflake warehouse manages the query execution process for the application. Each Snowflake warehouse is independent from one another and must be accessed individually when bringing data over to Platform.

For more information about these values, refer to this Snowflake document.

In order to access your Snowflake account on Experience Platform, you must provide the following authentication value:

NOTE
You must set the PREVENT_UNLOAD_TO_INLINE_URL flag to FALSE to allow data unloading from your Snowflake database to Experience Platform.

Connect your Snowflake account

In the Platform UI, select Sources from the left navigation to access the Sources workspace.

You can select the appropriate category from the catalog on the left-hand side of your screen. Alternatively, you can find the specific source you wish to work with using the search bar.

Under the Databases category, select Snowflake and then select Add data.

The sources catalog with Snowflake highlighted.

The Connect to Snowflake page appears. On this page, you can either use new credentials or existing credentials.

Existing account

To use an existing account, select the Snowflake account you want to connect with and then select Next to proceed.

The existing account interface in the sources workflow.

New account

To create a new account, select New account, and then provide a name and an optional description for your new Snowflake account.

The new account interface in the sources workflow.

Account key authentication

To use account key authentication, provide your connection string in the input form and then select Connect to source.

The account key authentication interface.

Key-pair authentication

To use key-pair authentication, provide values for your account, username, private key, private key passphrase, database, and warehouse, then select Connect to source.

The account key-pair authentication interface.

Next steps

By following this tutorial, you have established a connection to your Snowflake account. You can now continue on to the next tutorial and configure a dataflow to bring data into Platform.

recommendation-more-help
337b99bb-92fb-42ae-b6b7-c7042161d089