Sending data from Adobe Analytics to Snowflake | Community
Skip to main content
A
AjayBhat1
April 13, 2023
Solved

Sending data from Adobe Analytics to Snowflake

  • April 13, 2023
  • 2 replies
  • 6084 views

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.

Best answer by Hemang35

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.

2 replies

Hemang35
Hemang35Accepted solution
Level 5
April 13, 2023

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.

    A
    AjayBhat1Author
    April 14, 2023

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

      M
      Mital_Bhalani
      June 12, 2024

      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
      Community Advisor
      Josh StephensCommunity Advisor
      Community Advisor
      April 14, 2023

      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.

        Terms & ConditionsAccessibility statement

        Loading footer...