Liquibase is very slow against snowflake during startup

[sadhnamanohar]

Description: The reason seems to be that it is running the following query 8 times during startup, and so takes 3 minutes before the changes start to get applied:

show /* JDBC:DatabaseMetaData.getColumns() */ columns in database "DEV"

In my DEV db, this query returns around. 100000 rows.

Environment: Liquibase version: 4.5.0 Driver: snowflake-jdbc-3.13.9.jar Liquibase extension: liquibase-snowflake-4.5.0.jar OS: MacOS

Expected/Desired Behavior: I believe the query could be: show /* JDBC:DatabaseMetaData.getColumns() */ columns in schema DEV.defaultSchemaName

Thanks

[molivasdat]

Hi @sadhnamanohar Thanks for letting us know about this issue. This may belong on the snowflake repository.

[KushnirykOleh]

Hi @sadhnamanohar. Snowflake support has been moved from extension to liquibase-core, along with this bunch of issues were fixed, including performance issue where schema was ignored for getMetadata() calls. Can you check with newest versions of Liquibase if issue still reproduces for you?