Liquibase generateChangelog, liquibase diff, liquibase diffChangeLog, liquibase snapshot are not working for Snowflake Database

General Discussion
1

Hi all,
I have been trying to use test few features (which are perfectly working for Oracle, Postgres) in snowflake and found that are not supported or not working currently.

liquibase generateChangelog, liquibase diff, liquibase diffChangeLog, liquibase snapshot are the features.
Are they not supported currently.

liquibase generateChangelog

Setting in Liquibase.properties:

changeLogFile=generated_changelog.xml
driver: net.snowflake.client.jdbc.SnowflakeDriver
url:jdbc:snowflake://******.us-east-1.snowflakecomputing.com/?role=irp_acs_dev&warehouse=wh_irp_etl&db=aha_enterprise
username: ******
password: ******

Command got executed successfully

Output: No information listed - generated_changelog.xml

liquibase diff

Setting in Liquibase.properties:

outputFile=diff_sf.txt
driver: net.snowflake.client.jdbc.SnowflakeDriver
url:jdbc:snowflake://******.us-east-1.snowflakecomputing.com/?role=irp_acs_dev&warehouse=wh_irp_etl&db=aha_enterprise
username: *****
password: *****
referenceDriver: net.snowflake.client.jdbc.SnowflakeDriver
referenceUrl:jdbc:snowflake://******us-east-1.snowflakecomputing.com/?role=irp_acs_test&warehouse=wh_irp_etl&db=aha_enterprise_raw_data
referenceUsername: *****
referencePassword: *****

Command got executed successfully:

Output: All information shows NONE – diff_sf.txt

liquibase diffChangeLog

Setting in Liquibase.properties:

changeLogFile=diff_changelog_sf.txt
driver: net.snowflake.client.jdbc.SnowflakeDriver
url:jdbc:snowflake://.us-east-1.snowflakecomputing.com/?role=irp_acs_dev&warehouse=wh_irp_etl&db=aha_enterprise
username: *****
password: *****
referenceDriver: net.snowflake.client.jdbc.SnowflakeDriver
referenceUrl:jdbc:snowflake://.us-east-1.snowflakecomputing.com/?role=irp_acs_test&warehouse=wh_irp_etl&db=aha_enterprise_raw_data
referenceUsername: *****
referencePassword: *****

Command got executed successfully

Output: Nothing has been captured – diff_changelog_sf.txt

liquibase snapshot

Setting in Liquibase.properties:

outputFile=snapshot_sf.yml
snapshotFormat=yml
driver: net.snowflake.client.jdbc.SnowflakeDriver
url:jdbc:snowflake://******.us-east-1.snowflakecomputing.com/?role=irp_acs_dev&warehouse=wh_irp_etl&db=aha_enterprise
username: *****
password: *****

Command got executed successfully

Output: Nothing has been captured – snapshot_sf.yml

Can anyone faced the same issues or know whether these are at all supported for snowflake.

2

Hi @biplab.adhikary,

I would recommend you file an issue with liquibase/snowflake extension, which maintains the snowflake functionality.

More snowflake community users will see the issue quicker over there.

Thanks,

Ronak