[Ultimate]{class="badge positive"}
Connect Snowflake to Experience Platform using the UI
Read this guide to learn how to connect your Snowflake account to Adobe Experience Platform using the 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 Experience Platform services.
- Sandboxes: Experience Platform provides virtual sandboxes which partition a single Experience Platform instance into separate virtual environments to help develop and evolve digital experience applications.
PREVENT_UNLOAD_TO_INLINE_URL flag to FALSE to allow data unloading from your Snowflake database to Experience Platform.Navigate the sources catalog navigate
In the Experience 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 option.
Select Snowflake under the Databases category, and then select Set up.
Use an existing account existing
Next, you are taken to the authentication step of the sources workflow. Here, you can either use an existing account or create a new account.
To use an existing account, select the Snowflake account you want to connect with and then select Next to proceed.
Create a new account create
If you do not have an existing account, then you must create a new account by providing the necessary authentication credentials that correspond with your source.
To create a new account, select New account and then provide a name and optionally add a description for your account.
Connect to Experience Platform on Azure azure
You can connect your Snowflake account to Experience Platform on Azure using either account key authentication or key-pair authentication.
To use account key authentication, select Account key authentication, provide your connection string in the input form and then select Connect to source.
| 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. Read the guide on retrieving your Snowflake account identifier for additional guidance. For more information, refer to the Snowflake documentation. |
| 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 Experience Platform. |
| Database | The Snowflake database contains the data you want to bring the Experience 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} |
To use key-pair authentication, select KeyPair authentication, provide values for your account, username, private key, private key passphrase, database, and warehouse, then select Connect to source.
With 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. Read the guide on retrieving your Snowflake account identifier for additional guidance. For more information, refer to the Snowflake documentation. |
| 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. Read the guide on retrieving your Snowflake private key for more information. |
| 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 Experience Platform. |
For more information about these values, refer to this Snowflake document.
Connect to Experience Platform on AWS aws
To create a new Snowflake account and connect to Experience Platform on AWS, ensure that you are in a VA6 sandbox and then provide the necessary credentials for authentication.
Skip preview of sample data skip-preview-of-sample-data
During the data selection step, you may encounter a timeout when ingesting large tables or files of data. You can skip data preview to circumvent the timeout and still view your schema, albeit without sample data. To skip data preview, enable the Skip previewing sample data toggle.
The rest of the workflow will remain the same. The only caveat is that skipping data preview may prevent calculated and required fields from being auto-validated during the mapping step, and you will then have to manually validate those fields during mapping.
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 Experience Platform.