在雪花上开始使用liquibase [英] getting started with liquibase on snowflake

问题描述

我正在尝试雪花上的liquibase.

I am trying to get started with liquibase on snowflake.

我想我和liquibase.properties文件差不多了

I think I am almost there with the liquibase.properties file

driver: net.snowflake.client.jdbc.SnowflakeDriver
classpath: ./liquibase-snowflake-1.0.jar
url: jdbc:snowflake://XXXXXX.us-east-1.snowflakecomputing.com
username: YYYYYYYYY
password: ZZZZZZZZZZ
changeLogFile: mySnowflakeChangeLog.xml

不幸的是，liquibase在尝试创建表databasechangelog和/或databasechangeloglock时抱怨没有当前数据库".

Unfortunately, liquibase complains about not having a "current database" when trying to create the tables databasechangelog and/or databasechangeloglock.

由于无法访问创建这些数据库表的sql脚本，我如何指示liquibase使用哪个数据库?

Since, I do not have access to the sql script creating these database tables, how do I instruct liquibase which DATABASE to use?

推荐答案

我在这里@Snowflake对一个内部团队进行了ping操作.他们建议:

I pinged an internal team here @Snowflake. They recommended:

将db = mydb数据库连接参数添加到URL ..或设置 用户的默认名称空间. default_namespace = mydb

adding db=mydb database connection parameter to the URL.. or set default namespace for the user.. alter user mike set default_namespace=mydb

希望有帮助！

这篇关于在雪花上开始使用liquibase的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！