Ultimate
Connect Snowflake to Experience Platform using the UI
- Topics:
- Sources
CREATED FOR:
- Developer
IMPORTANTRead this guide to learn how to connect your Snowflake account to Adobe Experience Platform using the user interface.
Getting started
WARNINGThis 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.
NOTEPREVENT_UNLOAD_TO_INLINE_URL flag to FALSE to allow data unloading from your Snowflake database to Experience Platform.Navigate the sources catalog
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.
TIP
Use an existing account
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
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
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.
orgname-account_name. Read the guide on retrieving your Snowflake account identifier for additional guidance. For more information, refer to the Snowflake documentation.PUBLIC.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.
orgname-account_name. Read the guide on retrieving your Snowflake account identifier for additional guidance. For more information, refer to the Snowflake documentation.For more information about these values, refer to this Snowflake document.
Connect to Experience Platform on AWS
AVAILABILITYTo 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
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.