search

Snowflake-Labs / schemachange

A Database Change Management tool for Snowflake
Apache License 2.0
517 stars 229 forks source link

How to use a custom prefix instead of "V" for Versioned Script Naming #234

Open Venkatak01 opened 9 months ago

Venkatak01 commented 9 months ago

What are you trying to accomplish? Describe what you are trying to accomplish with SchemaChange

In Flyway, we have the option to change the default prefix for versioned SQL migrations using the property "flyway.sqlMigrationPrefix" .Could you please let me know if there is a parameter in schemachange that allows us to overwrite the prefix for the file names?

What options have you tried so far ? Share any steps, examples, solutions (include links, if possible) you have tried.

We are successfully able to migrate files prefixed with V but we have a repo that have files prefixed with different string.so, need to know what is the parameter in schemachange to overwrite the default prefix.

sfc-gh-tmathew commented 7 months ago

@Venkatak01 There is no parameter to change the prefix of the file in schemachange.

As a workaround, You will have to script the renaming of files prior to calling schemachange until this issue is addressed by a feature release down the road. This is not a high priority item compared to other issues reported.