Solved

AEP snowflake source authentication to keyPair Authentication

Forum|Forum|4 months ago
September 2, 2025
3 replies
697 views

Hi Team,

In adobe AEP/AJO there is a recent change where the authentication for Snowflake needs to be changed from Basic Authentication to KeyPair Authentication.

The question i have is once i get the details from the Snowflake Admin team in order to create the source connector, is there a way to migrate the existing dataflows that are already feeding data into the AEO datasets or I will have to manually create the new connection and manually map the attributes for each dataset.

Please let me know in case anyone of you have already migrated or have a solution where i dont have to manually stop all the older dataflows and create all of them from scratch again using the new KeyPair Authentication.

Thanks,
Mohit

Experience Platform

Best answer by DavidKangni

@mohit_khare

Once you created the new source connection, easiest is to use import flow from the UI.

https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/ui/mapping#import-mapping

thanks,

David

SatheeskannaK

Community Advisor

@mohit_khare You should be able to update the connection details via API.

https://experienceleague.adobe.com/en/docs/experience-platform/sources/api-tutorials/update

Thanks, Sathees

mohit_khareAuthor

Hi @satheeskannak,

Thanks for the quick reply. Could you please help me with one more thing.

The documentation that you have shared seems to be working in case we need to change anything in an existing connection like the name, description, username, password etc.

But how can I change the existing authorization from Account Key Authentication to KeyPair Authentication for Snowflake, without creating a new account one.

SatheeskannaK

Community Advisor

I haven't tried that. But I'm under the impression, when you use the operation replace, it should allow you to change the existing authorization type.

Otherwise, try this approach: create a new source connection with the new credentials, then do a PATCH on the dataflow, replacing the new source connection ID.

Thanks, Sathees

DavidKangni

Accepted solution

Community Advisor

@mohit_khare

Once you created the new source connection, easiest is to use import flow from the UI.

https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/ui/mapping#import-mapping

thanks,

David

David Kangni

mohit_khareAuthor

Hi @davidkangni,

This seems to be the most possible option as of right now but was trying to find a way so that I dont have to manually import around 50 dataflow mappings into the new connection that I will have to create.

I will try both the ways and will keep you posted.

Sukrity_Wadhwa

Community Manager

Hi @mohit_khare,

Were you able to resolve this query with the help of the provided solutions, or do you still need further assistance? Please let us know. If any of the answers were helpful in moving you closer to a resolution, even partially, we encourage you to mark the one that helped the most as the 'Correct Reply.'

Thank you!

Sukrity Wadhwa

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded