snowflake-cloud-data-platform - 如何使用 DBT 使用 sso 身份验证连接雪花
问题描述
我正在尝试使用带有 SSO 身份验证机制的 DBT 连接雪花。为此,应打开一个外部浏览器窗口以传递凭据。为了与雪花连接,我构建了 profile.yml 文件,如下所示
test_dbt_snowflake:
target: dev
outputs:
dev:
type: snowflake
account: ****.east-us-2.azure
user: ****
role: sysadmin
# SSO config
authenticator: externalbrowser
database: tgt
warehouse: compute_wh
schema: tgt_schema
threads: 1
client_session_keep_alive: False
但是当我尝试连接时,会出现以下错误
Running with dbt=0.17.0
For upgrading instructions, consult the documentation:
https://docs.getdbt.com/docs/guides/migration-guide/upgrading-to-0-17-0
Found 1 model, 0 tests, 0 snapshots, 0 analyses, 136 macros, 0 operations, 0 seed files, 0 sources
Initiating login request with your identity provider. A browser window should have opened for you to complete the login. If you can't see it, check existing browser windows, or your OS settings. Press CTRL+C to abort and try again...
Encountered an error:
Runtime Error
Database error while listing schemas in database "tgt"
Database Error
390190 (08001): Failed to connect to DB: *****.east-us-2.azure.snowflakecomputing.com:443, There was an error related to the SAML Identity Provider account parameter. Contact Snowflake support.
解决方案
推荐阅读
- c - OpenCV无法识别网络摄像头,但mplayer成功
- algorithm - LZ77 和转义字符
- javascript - 返回并渲染 JSX
- python - 可以将 keras“flow_from_directory”与“.mat”文件一起使用吗?
- java - 用于“E”和“MMM”添加句点的 Java 10 DateTimeFormatter 模式符号
- java - 如何使用java替换pdf中的文本
- c - C:为什么printf语句后字符值会发生变化?
- javascript - 如何在反应中正确显示日期?
- javascript - 向 API 提交带有对象数组的 Javascript 对象
- bunifu - 如何使用 c# 中的 bunifuTransition 从右向左滑动面板