dbt Snowflake目标似乎不起作用。

huangapple go评论46阅读模式
英文:

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.

huangapple
  • 本文由 发表于 2023年2月16日 15:04:48
  • 转载请务必保留本文链接:https://go.coder-hub.com/75468837.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定