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

1 comment

  • 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

Add comment

Please sign in to leave a comment.