How can we help you today? How can we help you today?

Issue with Snowflake zero copy clone with repeatable scripts

Dear colleagues,

All time that I have to create a new database via Jenkins/Flyway, we use Snowflake zero copy clone  to be faster. However, all our repeatable scripts are relaunch because the checksum is not the same when Snowflake cloned the FLYWAY."flyway_schema_history" table. Is there a way to fix it? Thanks in advance

Rodrigo
0

Comments

2 comments

Sort by
  • willamabroy2

    Snowflake skips repeatable scripts on clones because it thinks they've already run. Fix it by giving scripts unique names per clone or resetting the change history.

    willamabroy2
    0
  • Rodrigo

    Hi Wiliam.

    In fact Flyway do not skip my SQL Scripts. In fact, it re-runs in Snowflake, even though the SQL scripts are the same and with the same name.

    I found the problem in my Jenkins file. I have to fix it. Thanks anyways.

    Rodrigo
    0

Add comment

Please sign in to leave a comment.