Create a Snowflake source connection in the UI

NOTE

The Snowflake connector is in beta. See the Sources overview for more information on using beta-labelled connectors.

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 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

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

Credential Description
Account The Snowflake account you want to connect to 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.
Database The Snowflake contains the data you want to bring the Platform.
Username The username for the Snowflake account.
Password The password for the Snowflake user account.
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}.

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

Connect your Snowflake account

In the Platform UI, select Sources from the left navigation to access the Sources workspace. The Catalog screen displays a variety of sources that you can create an account with.

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 Connect to Snowflake page appears. On this page, you can either use new credentials or existing credentials.

Existing account

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

New account

If you are using new credentials, select New account. On the input form that appears, provide a name, an optional description, and your Snowflake credentials. When finished, select Connect and then allow some time for the new connection to establish.

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.

On this page