Snowflake destination in AEP | Community
Skip to main content
A
AjayBhat1
New Member
May 13, 2023
Solved

Snowflake destination in AEP

  • May 13, 2023
  • 2 replies
  • 2664 views

Hello @jennifer_dungan , Please let me know the process that one can follow to create a Snowflake destination in AEP. When I am in the "Destinations" tab of AEP, I do not see a connector today available in the catalog for Snowflake. 

Thanks,

Warm regards,

Ajay

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by PratheepArunRaj

Dear @ajaybhat1 ,

Have moved the discussion to the Adobe Experience Platform Questions.

Snowflake as a source connector is available, however, destination is not available by default.

If Snowflake supports data ingestion through API, you can use the 'HTTP API' connection from Streaming Destination which is pretty straightforward. Until you have the Snowflake destination, 'HTTP API' is the alternative option without involving medial storage like S3, Azure, FTP etc.

Thank You, Pratheep Arun Raj B (Arun) | NextRow Digital | Terryn Winter Analytics

 

2 replies

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
May 14, 2023

Hi @ajaybhat1,

 

We only have Adobe Analytics, so I do actually have access to AEP Destinations... We get our data into Snowflake using Adobe Analytics Raw Data Feeds and sending them to an S3 bucket... then our data team picks up those files and uses an ETL process to read the data and apply similar logic to Adobe do that the reports they pull from the Data Lake match up as closely as possible to the reports I pull directly from Adobe.

 

From what I can see from the documentation, Amazon S3 buckets are available.. I expect that the data coming from here is processed by Adobe already (since I see options like "de-duplication"), so there would be less work on the ETL process (but again, I am guessing since I haven't used this myself).

 

 

I did also find this.. so it seems like there should be a connector available
https://experienceleague.adobe.com/docs/experience-platform/sources/connectors/databases/snowflake.html?lang=en 

 

Hopefully this helps you.

PratheepArunRaj
Community Advisor and Adobe Champion
PratheepArunRajCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
May 14, 2023

Dear @ajaybhat1 ,

Have moved the discussion to the Adobe Experience Platform Questions.

Snowflake as a source connector is available, however, destination is not available by default.

If Snowflake supports data ingestion through API, you can use the 'HTTP API' connection from Streaming Destination which is pretty straightforward. Until you have the Snowflake destination, 'HTTP API' is the alternative option without involving medial storage like S3, Azure, FTP etc.

Thank You, Pratheep Arun Raj B (Arun) | NextRow Digital | Terryn Winter Analytics

 

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
    Terms & ConditionsAccessibility statement

    Loading footer...