When Snowflake Fails Over

[ksouthgate]

When an instance of Snowflake fails over to another secondary Snowflake account, is there a way to dynamically have the SnapLogic account find which Snowflake account is the new primary? Is there a way to query which of 2 Snowflake accounts are the primary?

[ksouthgate · Accepted solution]

I’ve found out what needs to be done, Snowflake provides client redirect which automatically realigns the connection url to the current primary account.

https://docs.snowflake.com/en/user-guide/client-redirect