dbt-snowflake: [CT-1619] [Bug] Could not connect to Snowflake backend after 0 attempt(s)

Is there an existing issue for this?

I have searched the existing issues

Current Behavior

post upgrade to 1.0.0 dbt cli is not connecting to snowflake

Expected Behavior

connect to snowflake after running dbt debug

Steps To Reproduce

Upgrade to dbt 1.0.0 execute dbt debug

Relevant log output

20:30:54  Running with dbt=1.0.0
dbt version: 1.0.0
python version: 3.9.9
python path: /usr/local/Cellar/dbt-snowflake/1.0.0/libexec/bin/python3.9
os info: macOS-12.0.1-x86_64-i386-64bit
Using profiles.yml file at /Users/me/.dbt/profiles.yml
Using dbt_project.yml file at /Users/me/Documents/Intellij Projects/gl/dbt/dbt_project.yml

Configuration:
  profiles.yml file [OK found and valid]
  dbt_project.yml file [OK found and valid]

Required dependencies:
 - git [OK found]

Connection:
  account: ********
  user: ********
  database: ********
  schema: ********
  warehouse: ********
  role: ********
  client_session_keep_alive: False
  Connection test: [ERROR]

1 check failed:
dbt was unable to connect to the specified database.
The database returned the following error:

  >Database Error
  250001: Could not connect to Snowflake backend after 0 attempt(s).Aborting

Check your database credentials and try again. For more information, visit:
https://docs.getdbt.com/docs/configure-your-profile

Environment

- OS:MacOS Monterey
- Python: 3.9.9
- dbt: 1.0.0

What database are you using dbt with?

snowflake

Additional Context

I have upgraded via homebrew to dbt 1.0.0 and just like that all connections to snowflake stopped working.

About this issue

Original URL
State: closed
Created 3 years ago
Comments: 18 (7 by maintainers)

Most upvoted comments

// edit - I had followed the instruction to put .aws at the end of the connection but removing it connected ok.

I can confirm that removing the aws at the end of the account string makes the connection succeed. thanks @Nathancalon

lmmentel on Feb 7, 2022

Thanks - Europe/Frankfurt - it doesn’t Thanks for the help. Everything is working now.

On 18 Dec 2021, at 17:00, Anton Huck @.***> wrote:

What region are you in? Please refer to this list on how to provide the Account identifier: https://docs.snowflake.com/en/user-guide/admin-account-identifier.html#account-identifier-formats-by-cloud-platform-and-region https://docs.snowflake.com/en/user-guide/admin-account-identifier.html#account-identifier-formats-by-cloud-platform-and-region Some of the regions don’t require the cloud identifier.

— Reply to this email directly, view it on GitHub https://github.com/dbt-labs/dbt-snowflake/issues/70#issuecomment-997222829, or unsubscribe https://github.com/notifications/unsubscribe-auth/AVK5KTX34YSBJYWQ5F7PPITURSV3BANCNFSM5KHKQQSQ. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. You are receiving this because you were mentioned.

Nathancalon on Dec 18, 2021

I’ve just installed and had the same issue (this is under Mac silicon with rosetta, which I have had issues with before but never finally fixed).

I just tried that install you suggested and it fails again. Really getting annoyed with dbt now, it just never seems to work with Snowflake on my Mac

// edit - I had followed the instruction to put .aws at the end of the connection but removing it connected ok.

Nathancalon on Dec 18, 2021