# How to use Snowflake extension

**URL:** <https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072>\
**Category:** General Discussion\
**Created:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072 "2020-01-29T21:40:00Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![un1398357527727r51id](https://avatars.discourse-cdn.com/v4/letter/u/da6949/32.png) [@un1398357527727r51id](https://forum.liquibase.org/u/un1398357527727r51id)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/1 "2020-01-29T21:40:00Z")

</div>

Hey, murali! Are you a Snowflake employee or customer? Thanks!

---

<div class="post-metadata">

**Author:** ![un1382561729492r88id](https://avatars.discourse-cdn.com/v4/letter/u/c4cdca/32.png) [@un1382561729492r88id](https://forum.liquibase.org/u/un1382561729492r88id)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/2 "2020-01-29T21:40:00Z")

</div>

I spent some time today working through some attempts to use the snowflake extension. There appear to be some significant issues with the plugin. The only way I was able to get it to work was to use Liquibase 3.5.3 (released October 2016, downloaded from github) along with a self-built version of liquibase-snowflake built from the latest version of the code on github. I was able to deploy some changes using both a formatted sql changelog and an XML changelog.&nbsp;

There are some open issues on the liquibase-snowflake extension that have not been addressed at all in the last 2 years, so I suspect it may have been abandoned. At Datical, we have started getting more inquiries about snowflake, so we will spend some time soon looking at forking this extension and bringing it into the Liquibase organization, but I can’t make any promises about the timing of that. If we were to do that we would also make sure that it worked well with the latest version of Liquibase.

Steve Donie  
Principal Software Engineer  
Liquibase Community Engagement  
Datical, Inc. [http://www.datical.com/](http://www.datical.com/)

---

<div class="post-metadata">

**Author:** ![un1382561729492r88id](https://avatars.discourse-cdn.com/v4/letter/u/c4cdca/32.png) [@un1382561729492r88id](https://forum.liquibase.org/u/un1382561729492r88id)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/3 "2020-01-29T21:40:00Z")

</div>

I have created&nbsp;[https://liquibase.jira.com/browse/CORE-3574](https://liquibase.jira.com/browse/CORE-3574)&nbsp;to track this.&nbsp;

Steve Donie  
Principal Software Engineer  
Liquibase Community Engagement  
Datical, Inc. [http://www.datical.com/](http://www.datical.com/)

---

<div class="post-metadata">

**Author:** ![un1382561729492r88id](https://avatars.discourse-cdn.com/v4/letter/u/c4cdca/32.png) [@un1382561729492r88id](https://forum.liquibase.org/u/un1382561729492r88id)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/4 "2020-01-29T21:40:00Z")

</div>

Thanks so much Bruce! Much appreciated.&nbsp;

Steve Donie  
Principal Software Engineer  
Liquibase Community Engagement  
Datical, Inc. [http://www.datical.com/](http://www.datical.com/)

---

<div class="post-metadata">

**Author:** ![un1382561729492r88id](https://avatars.discourse-cdn.com/v4/letter/u/c4cdca/32.png) [@un1382561729492r88id](https://forum.liquibase.org/u/un1382561729492r88id)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/5 "2020-01-29T21:40:00Z")

</div>

Bruce, a question for you - the source for this was originally at&nbsp;[https://github.com/CDKGlobal/liquibase-snowflake](https://github.com/CDKGlobal/liquibase-snowflake), but I see that you have forked that to&nbsp;[https://github.com/bruce-szalwinski/liquibase-snowflake](https://github.com/bruce-szalwinski/liquibase-snowflake)

As you are the author of both, should the community consider your fork to be the ‘canonical’ fork at this time? If so, is there any way you could get the CDKGlobal version marked as ‘deprecated’ and your fork marked as ‘latest and greatest’?

Thank you,

Steve Donie  
Principal Software Engineer  
Liquibase Community Engagement  
Datical, Inc. [http://www.datical.com/](http://www.datical.com/)

---

<div class="post-metadata">

**Author:** ![murali](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@murali](https://forum.liquibase.org/u/murali)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/6 "2020-01-29T21:40:00Z")

</div>

Hello All,

I am very new to liquibase , i am setting up to deploy snowflake changes (without maven or ant ) . i am wondering how to use snowflake extension jar file&nbsp;[https://liquibase.jira.com/wiki/spaces/CONTRIB/pages/113372651/Snowflake+extension](https://liquibase.jira.com/wiki/spaces/CONTRIB/pages/113372651/Snowflake%2Bextension)&nbsp;.

I copied it to same class path as dbchangelog, but it is throwing an error&nbsp;  
Unexpected error running Liquibase: class liquibase.ext.database.SnowflakeDatabase overrides final method addReservedWords.(Ljava/util/Collection;).

Without this extension i am able to deploy changes.

My changelog looks like this way , please assist where to place .jar file and any other configs.

>

---

<div class="post-metadata">

**Author:** ![un87635751830382875r](https://avatars.discourse-cdn.com/v4/letter/u/f6c823/32.png) [@un87635751830382875r](https://forum.liquibase.org/u/un87635751830382875r)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/7 "2020-01-29T21:40:00Z")

</div>

Thanks Steve for looking into this, Is there any feature request from datical we can follow up on progress?

---

<div class="post-metadata">

**Author:** ![un87635751830382875r](https://avatars.discourse-cdn.com/v4/letter/u/f6c823/32.png) [@un87635751830382875r](https://forum.liquibase.org/u/un87635751830382875r)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/8 "2020-01-29T21:40:00Z")

</div>

Hi Robert,

I am snowflake customer , learning snowflake 🙂

Regards,

Murali

---

<div class="post-metadata">

**Author:** ![un87635751830382875r](https://avatars.discourse-cdn.com/v4/letter/u/f6c823/32.png) [@un87635751830382875r](https://forum.liquibase.org/u/un87635751830382875r)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/9 "2020-01-29T21:40:00Z")

</div>

Many Thanks Steve.

---

<div class="post-metadata">

**Author:** ![un88039526946091504r](https://avatars.discourse-cdn.com/v4/letter/u/e5b9ba/32.png) [@un88039526946091504r](https://forum.liquibase.org/u/un88039526946091504r)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/10 "2020-01-29T21:40:00Z")

</div>

Thanks for your interest in the liquibase-snowflake plugin.&nbsp; I was the original author, but haven’t maintained it in quite some time.&nbsp; I recently had the opportunity to do some work with Snowflake so took the opportunity to upgrade the plugin to the latest liquibase release, 3.8.5.&nbsp; You can find the source at&nbsp;[https://liquibase.jira.com/wiki/spaces/CONTRIB/pages/113372651/Snowflake+extension](https://liquibase.jira.com/wiki/spaces/CONTRIB/pages/113372651/Snowflake%2Bextension).&nbsp; You can also find a sample implemenation at&nbsp;[https://github.com/bruce-szalwinski/liquibase-snowflake-sample](https://github.com/bruce-szalwinski/liquibase-snowflake-sample)

---

<div class="post-metadata">

**Author:** ![un88039526946091504r](https://avatars.discourse-cdn.com/v4/letter/u/e5b9ba/32.png) [@un88039526946091504r](https://forum.liquibase.org/u/un88039526946091504r)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/11 "2020-01-29T21:40:00Z")

</div>

Yes, I would think the fork at&nbsp;[https://github.com/bruce-szalwinski/liquibase-snowflake](https://github.com/bruce-szalwinski/liquibase-snowflake)&nbsp;should be the “canonical” fork.&nbsp; I’ll try and contact the folks at CDKGlobal to see if they can mark my original work as deprecated.&nbsp; I can update the README in my fork to say “latest and greatest”.

---

<div class="post-metadata">

**Author:** ![un78382703536483728r](https://avatars.discourse-cdn.com/v4/letter/u/d9b06d/32.png) [@un78382703536483728r](https://forum.liquibase.org/u/un78382703536483728r)\
**Post date:** [January 29, 2020, 9:40pm UTC](https://forum.liquibase.org/t/how-to-use-snowflake-extension/4072/12 "2020-01-29T21:40:00Z")

</div>

I was also working with liquibase for a while.

If it helps here’s the example how I did it.

[https://github.com/hello-ish/liquibase-snowflake-sample](https://github.com/hello-ish/liquibase-snowflake-sample)

NOTE: Many thanks and credit goes to Bruce.
