Snowflake Generate Changelog

Liquibase Users
#1

Now i see snowflake is under liquibase supported db list, Does liquibase now support databasechangelog file creation for snowflake ?

I get following error when try to run log generation command : Unexpected error running Liquibase: liquibase.snapshot.InvalidExampleException: Found multiple catalog/schemas matching.

of course i’m using schema,db name in url abd as well liquibaseschemaname : schema also in properties.

Please realize me why i get this error.

1 Like
#2

I have the exact same problem with 4.1.0 :frowning:

The only time i managed to go a bit further was when i tested with schema name that doesn’t exists in any other database. Which isn’t really a solution.

But they I got the following error: don’t know how to query for sequences on …

#3

In your liquibase.properties:


define includeSchema true and includeCatalog. true and define default catalog and default schema
Ex i created a DEMO_DB and 2 catalogs:
“DEMO_DB”.“DEMO”.“TABLE1”;
Because you can have multiple catalog “DEMO_DB”.“PUBLIC”.“TABLE1”
schema: DEMO_DB:
catalogs:
DEMO
PUBLIC
1 Like
#4

Found the same issue in Snowflake.is this yet to be supported?