null
as an empty string. Contact your Adobe representative to ensure that your null
values are correctly written as null
in Adobe Experience Platform.Adobe Experience Platform allows data to be ingested from external sources while providing you with the ability to structure, label, and enhance incoming data using Platform services. You can ingest data from a variety of sources such as Adobe applications, cloud-based storage, databases, and many others.
Experience Platform provides support for ingesting data from a third-party database. Platform can connect to different types of databases such as relational, NoSQL, or data warehouses. Support for database providers include Snowflake.
This section outlines the setup tasks that you need to complete before you can connect your Snowflake source to Experience Platform.
You must retrieve your account identifier from the Snowflake UI dashboard because you will be using the account identifier to authenticate your Snowflake instance on Experience Platform.
To retrieve your account identifier:
If you are using key-pair authentication for your Snowflake connection, then you must also generate your private key before connecting to Experience Platform.
To generate your encrypted Snowflake private key, run the following command on your terminal:
openssl genrsa 2048 | openssl pkcs8 -topk8 -v2 des3 -inform PEM -out rsa_key.p8
If successful, you should receive your private key in PEM format.
-----BEGIN ENCRYPTED PRIVATE KEY-----
MIIE6T...
-----END ENCRYPTED PRIVATE KEY-----
To generate your unencrypted Snowflake private key, run the following command on your terminal:
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt
If successful, you should receive your private key in PEM format.
-----BEGIN PRIVATE KEY-----
MIIE6T...
-----END PRIVATE KEY-----
Next, take your private key and encode it in Base64. Ensure that you do not do any transformations or format conversions on your Snowflake private key. Additionally, you must ensure that there are no trailing newline characters at the end of your private key, before encoding it in Base64.
Before you can create a source connection for your Snowflake data, you must also ensure that the following configurations are met:
To verify your role and warehouse:
...
) on the top-right corner.Once successfully encoded, you may then used that Base64-encoded private key on Experience Platform to authenticate your Snowflake account.
A list of IP addresses must be added to an allow list prior to working with source connectors. Failing to add your region-specific IP addresses to your allow list may lead to errors or non-performance when using sources. See the IP address allow list page for more information.
The documentation below provides information on how to connect Snowflake to Platform using APIs or the user interface: