# Need a sample YAML File for GitHub Workflow

**URL:** <https://forum.liquibase.org/t/need-a-sample-yaml-file-for-github-workflow/7488>\
**Category:** General Discussion\
**Created:** [November 2, 2022, 2:07pm UTC](https://forum.liquibase.org/t/need-a-sample-yaml-file-for-github-workflow/7488 "2022-11-02T14:07:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajeshco80](https://avatars.discourse-cdn.com/v4/letter/r/c4cdca/32.png) [@rajeshco80](https://forum.liquibase.org/u/rajeshco80)\
**Post date:** [November 2, 2022, 2:07pm UTC](https://forum.liquibase.org/t/need-a-sample-yaml-file-for-github-workflow/7488/1 "2022-11-02T14:07:30Z")

</div>

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.

Thanks.

R. Co

---

<div class="post-metadata">

**Author:** ![tabbyfoo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/tabbyfoo/32/748_2.png) [@tabbyfoo](https://forum.liquibase.org/u/tabbyfoo)\
**Post date:** [November 2, 2022, 4:03pm UTC](https://forum.liquibase.org/t/need-a-sample-yaml-file-for-github-workflow/7488/2 "2022-11-02T16:03:32Z")

</div>

Hey there, @rajeshco80 - Welcome to the Liquibase Community!

There are several examples you can use here:

> **[liquibase-toolbox/build\_scripts\_examples at master · liquibase/liquibase-toolbox](https://github.com/liquibase/liquibase-toolbox/tree/master/build_scripts_examples)**
>
> master/build\_scripts\_examples

And a YAML example here:

> <https://github.com/liquibase/liquibase-toolbox/blob/master/build_scripts_examples/GitHub_Actions/workflow_ubuntu_cli-latest.yml>

Hope that helps you to get started.

Kindly,  
Tabby

---

<div class="post-metadata">

**Author:** ![rajeshco80](https://avatars.discourse-cdn.com/v4/letter/r/c4cdca/32.png) [@rajeshco80](https://forum.liquibase.org/u/rajeshco80)\
**Post date:** [November 2, 2022, 10:29pm UTC](https://forum.liquibase.org/t/need-a-sample-yaml-file-for-github-workflow/7488/4 "2022-11-02T22:29:34Z")

</div>

@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?

Thanks.

R. Co

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [November 7, 2022, 9:11pm UTC](https://forum.liquibase.org/t/need-a-sample-yaml-file-for-github-workflow/7488/5 "2022-11-07T21:11:59Z")

</div>

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

Nathan
