Failover Recovery in snowflake database

Kishore Kumar Adari 21 Reputation points
2022-08-25T09:44:36.847+00:00

Hello Team,
From 3rd party system we receive DDL and DML scripts and they have to be executed into snowflake. If there is any failure during execution of DDL and DML scripts I have to rollback to previously stable state. How can I do it?

Is it possible to create replica of existing snowflake database on the fly and execute the DDL and DML scripts into the replica? so if new replica is stable we can use it else to use old database?

or is there any better option available to perform rollback to previous stable state?

Community Center | Not monitored
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. SSingh-MSFT 16,371 Reputation points Moderator
    2022-08-26T06:35:15.183+00:00

    Hi @Kishore Kumar Adari ,

    Thank you for posting your question in Microsoft Q&A platform.

    Regarding this question on Failover Recovery in Snowflake database, could you please post in the Snowflake forum to get support from Snowflake community.

    Hope this will help in getting your ask answered. Have a good day!

    Regards,
    ShaktiSingh-MSFT

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.