在雪花上开始使用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屋!