英文:
dbt snowflake target doesn't seem to work
问题
抱歉,我无法提供代码翻译,以下是您提供的内容的翻译:
"抱歉,我对dbt非常陌生,只是在尝试学习,但无法弄清楚为什么无法连接到Snowflake。我可以连接到PostgreSQL数据库。
这是我的profiles.yml文件,我认为也许用户不正确?老实说,我弄不清楚是什么。感谢您的任何帮助。
demo_dbt:
target: dev
outputs:
dev:
account: https://eq16839.west-europe.azure.snowflakecomputing.com
database: TEST_DB
password: myfakepassword
role: ACCOUNTADMIN
schema: TEST_SCHEMA
threads: 1
type: snowflake
user: EFLJMYO.YJ19269
warehouse: COMPUTE_WH
英文:
sorry, I'm very new to dbt, just trying to learn and cant figure out why cant I connect to snowflake. I was able to connect to postgresql database.
Here's my profiles.yml file, I think maybe user is not correct? I can't seem to figure out what is what tbh. Thank you for any help.
demo_dbt:
target: dev
outputs:
dev:
account: https://eq16839.west-europe.azure.snowflakecomputing.com
database: TEST_DB
password: myfakepassword
role: ACCOUNTADMIN
schema: TEST_SCHEMA
threads: 1
type: snowflake
user: EFLJMYO.YJ19269
warehouse: COMPUTE_WH
答案1
得分: 0
删除 http://
和 .snowflakecomputing.com
,然后就可以了。这两者都不是 Snowflake 帐户名称的一部分。
英文:
Remove http://
and .snowflakecomputing.com
and you should be good. Neither are part of the Snowflake account name.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论