Sending data from Adobe Analytics to Snowflake | Community
Skip to main content
AjayBhat1
New Participant
Apr 13, 2023 6:07 PM UTC
Solved

Sending data from Adobe Analytics to Snowflake

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
Hemang35Accepted solution
Level 5
Apr 13, 2023 7:26 PM UTC

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.

View reply

4 replies

Josh__Stephens
Josh__Stephens
New Participant
Apr 14, 2023 5:32 PM UTC

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.

Translate
    Hemang35
    Hemang35Accepted solution
    Level 5
    Apr 13, 2023 7:26 PM UTC

    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.

    Translate
      AjayBhat1Author
      New Participant
      Apr 14, 2023 10:42 PM UTC

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

      Translate
        Mital_Bhalani
        New Participant
        Jun 12, 2024 12:04 PM UTC

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

        Translate
        Terms & ConditionsAccessibility statement

        Loading footer...