我有一个自定义Databricks实例,其域名指向AWS负载均衡器。当我使用这里的HTTP指令或这里的databricks集群指令输入这些信息时,我会在DBT CLI:中得到以下响应
Connection:
host: https://subdomain.domain.com
port: 443
cluster: 123456-stuff00003
endpoint: None
schema: default
organization: 0
16:40:39.470091 [debug] [MainThread]: Acquiring new spark connection "debug"
16:40:39.471632 [debug] [MainThread]: Using spark connection "debug"
16:40:39.472524 [debug] [MainThread]: On debug: select 1 as id
16:40:39.472953 [debug] [MainThread]: Opening a new connection, currently in state init
Connection test: [ERROR]
1 check failed:
dbt was unable to connect to the specified database.
The database returned the following error:
>Runtime Error
Database Error
failed to connect
不幸的是,DBT的调试日志非常糟糕,我不完全确定它为什么会失败。我知道,当我通过Intellij连接到集群时,我必须提供CA file
、Client Certificate file
和Client key file
,因为我使用的是自签名SSL证书(不幸的是,需要自签名证书(。此外,在定义我的~/.databrickscfg
文件时,我必须提供参数insecure = true
。
我最近遇到了这个问题,我通过执行;安装证书。命令";python主目录中用于运行dbt的脚本。
Laurent