Sending data from Adobe Analytics to Snowflake

[AjayBhat1]

What is the best and most efficient way of sending data from Adobe Analytics to Snowflake? The ask is to send all clickstream data from Adobe Analytics to Snowflake. Please let me know. Thanks.

[Hemang35 · Accepted solution]

Hello @AjayBhat1 

To efficiently send clickstream data from Adobe Analytics to Snowflake, use Adobe Experience Platform (AEP). Configure Data Export Controls in Adobe Analytics, set up Adobe Analytics as a data source in AEP, and create a Snowflake destination. Create a data flow in AEP to map data between the two systems, schedule the data flow, and monitor its execution. This approach ensures seamless data transfer and leverages AEP's powerful data processing capabilities.

Let me know if you still need help.

[AjayBhat1]

@Hemang35 By creating a snowflake destination I am assuming you are asking to create it in Connections > Destinations. But, I do not see Snowflake as an option in the Catalog. How should I go about setting this up? 

[Mital_Bhalani]

Correct there is not direct connection form AEP to snowflake data Migration, is there any way we can achieve it directly, without sending it to Blob Storage ??

[Josh__Stephens]

Snowflake also has a preview feature for S3-compatible endpoints.  You can use Adobe Analytics Data Feeds to easily send clickstream data to S3 buckets.