Hello Everyone, I’m new to Liquibase and trying to evaluate Liquibase for our new customer to apply database schema changes to their Snowflake database environment. All the DDLs and DMLs are stored in GitHub repository. Using the GitHub workflow, we are trying to deploy the SQLs into Snowflake.
Can anyone please share the sample YAML file that I can use in GitHub workflow that uses Liquibase to deploy the changes to Snowflake? Your help is very much appreciated.
Hey there, @rajeshco80 - Welcome to the Liquibase Community!
There are several examples you can use here:
And a YAML example here:
Hope that helps you to get started.
@tabbyfoo, Thanks a lot for sharing the GIT Sites. They have been really helpful. I have used the command below :
./liquibase --defaultsFile=./liquibase.properties --defaultSchemaName=CICD_DEMO_DB.LIQUIBASE --logLevel=debug update
But getting the following error.
Unexpected error running Liquibase: Cannot perform CREATE TABLE. This session does not have a current database. Call ‘USE DATABASE’, or use a qualified name. [Failed SQL: (90105) CREATE TABLE “CICD_DEMO_DB.LIQUIBASE”.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP_NTZ, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]
Instead of “CICD_DEMO_DB.LIQUIBASE”, it should be “CICD_DEMO_DB”.“LIQUIBASE” OR is there any other solution for this error?
That seems like an issue with how you are connecting to the datababase. SqlServer is it?
Either setting the database name in the URL like
jdbc:sqlserver://localhost;databaseName=myDatabase or using --defaultCatalogName should help