# Redshift extension

**URL:** <https://forum.liquibase.org/t/redshift-extension/4394>\
**Category:** General Discussion\
**Created:** [July 14, 2020, 1:31pm UTC](https://forum.liquibase.org/t/redshift-extension/4394 "2020-07-14T13:31:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gili](https://avatars.discourse-cdn.com/v4/letter/g/7feea3/32.png) [@gili](https://forum.liquibase.org/u/gili)\
**Post date:** [July 14, 2020, 1:31pm UTC](https://forum.liquibase.org/t/redshift-extension/4394/1 "2020-07-14T13:31:42Z")

</div>

how do configure liquibase.properties using redshift extension?  
i’m referencing the jar:

classpath: src/main/resources/liquibase-redshift-3.10.1.jar

tried both  
driver: com.amazon.redshift.jdbc42.Driver  
or  
driver: com.amazon.redshift.jdbc.Driver

and i keep getting an error  
“Cannot find database driver: com.amazon.redshift.jdbc.Driver”

using JDBC driver works fine, but the changelog file does not contain sort keys, dist keys  
this is how how configured the connection that worked but didn’t import sort keys and dist keys:

driver: com.amazon.redshift.jdbc42.Driver  
classpath: src/main/resources/RedshiftJDBC42-1.2.16.1027.jar

would love some help here

---

<div class="post-metadata">

**Author:** ![ronak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/ronak/32/221_2.png) [@ronak](https://forum.liquibase.org/u/ronak)\
**Post date:** [July 14, 2020, 2:50pm UTC](https://forum.liquibase.org/t/redshift-extension/4394/2 "2020-07-14T14:50:18Z")

</div>

Hi @gili, welcome to the forum!

I have seen this issue before, what version of Liquibase are you using?

A known workaround is to put the url, user and password in the commandline and not take values from the liquibase properties file

liquibase --url="[JDBCURL]" --username=scott --password=tiger

Where JDBCURL could be something like: `jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev`

Which my collegue @MikeOlivas found on this [page](https://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html).

If you try that, do you get the same error message?

-Ronak

---

<div class="post-metadata">

**Author:** ![gili](https://avatars.discourse-cdn.com/v4/letter/g/7feea3/32.png) [@gili](https://forum.liquibase.org/u/gili)\
**Post date:** [July 15, 2020, 8:42am UTC](https://forum.liquibase.org/t/redshift-extension/4394/3 "2020-07-15T08:42:18Z")

</div>

yes, i do get the same error “Cannot find database driver: …”  
ran the command this way:

liquibase --changeLogFile=changelog.redshift.sql --schemas=atomic,agg --includeSchema=true --includeTablespace=true --url=“jdbc:redshift:xxxxxx.xxxxxx.us-east-1.redshift.amazonaws.com:5439/xxxx” --username=xxxx --password=xxxxx generateChangeLog

does the redshift extention solve the sort key/dist key issue? can i except generateChangeLog command generate the sort and dist keys when using classpath: src/main/resources/liquibase-redshift-3.10.1.jar?

---

<div class="post-metadata">

**Author:** ![ronak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/ronak/32/221_2.png) [@ronak](https://forum.liquibase.org/u/ronak)\
**Post date:** [July 15, 2020, 2:16pm UTC](https://forum.liquibase.org/t/redshift-extension/4394/4 "2020-07-15T14:16:53Z")

</div>

Hey @gili, (cc @MikeOlivas)

Just had this issue brought up in standup, looks like this discussion issue is not up to date. I hear you have been able to connect? And now you are getting an error I believe in snapshotting?

If there is an error, could we move this to reporting the bug on the redshift extension if the above is true:

> **[liquibase/liquibase-redshift](https://github.com/liquibase/liquibase-redshift/issues)**
>
> Liquibase support for Redshift. Contribute to liquibase/liquibase-redshift development by creating an account on GitHub.

Would you also mind sharing the connection string that worked for you so we can add that to documentation and it could help out others that had the same issue you did?

Thanks!

Ronak