Liquibase to Snowflake DevOps

Community Answers
, ,
1

Hi ,

I’m trying to implement DevOps using Liquibase.

liquibase.properties file.

When I run “liquibase state” it always gives incorrect username and password though I can login from browser with the same creds.

Error below

Unexpected error running Liquibase: Connection could not be created to jdbc:snowflake://*********.snowflakecomputing.com/?db=dbname&schema=schema_name with driver net.snowflake.client.jdbc.SnowflakeDriver. Incorrect username or password was specified.

Any ideas!!

Thanks!!
Manoj

changeLogFile=changelog.xml
driver= net.snowflake.client.jdbc.SnowflakeDriver
classpath=/opt/liquibase/internal/
url= jdbc:snowflake://**********.snowflakecomputing.com/?db=dbname&schema=schema_name
username: ******
password: &&&&&&&&&
logLevel: INFO
logFile: liquibase.log
liquibase.hub.mode=off
liquibase.changelogSchemaName = CORP_CONFIG

1 Like
2

Hi @Manoj Welcome to the community. There are a few things that you might be able to try.

  1. The url is different from the typed in value in the browser and gets redirected to the real hostname. Us that hostname in your jdbc url in front of the snowflakecomputing.com part of the jdbc url.
  2. The password has an invalid character that gets parsed by the command line instead.
  3. the user connecting does not have access to the CORP_CONFIG schema in the database.
1 Like
3

Hi Mike,

This was due to password which is having special chars.

Thanks for the support!!
Thanks!!
Manoj

1 Like