Adobe Journey Optimizer

mohit_khare · 9/2/25

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

SatheeskannaK · 9/2/25

@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_khare · 9/2/25

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 · 9/2/25

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

mohit_khare · 9/5/25

Hi @SatheeskannaK,

I will try this approach, but not sure if it will allow me to change the connection ID through API.

Will keep you posted.

DavidKangni · 9/4/25

@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_khare · 9/5/25

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.