Snowflake: dbt was unable to connect to the specified database.

Help
1

I am trying to complete the Fundamentals learning, everything has been great except for this, which is very frustrating. (I changed the actual org/accounts slightly for privacy)

My snowflake URL is: https://app.snowflake.com/utmtger/bsd82187/#/workspaces/ws…

I am on AWS - US West, when I click my initials in the lower left it says “Account” then the AWS logo and BSD82187

When I click on the Account details it has:

Account Identifier: UTMTGER-BSD82187
Data Sharing Account Identifier: UTMTGER.BSD82187
Organization Name: UTMTGER
Account Name: BSD82187

In my connection settings I put

Account: BSD82187
Database: ANALYTICS (I created it in all lowercase, but in Snowflake it displays all caps, I’ve tried both ways)
Warehouse: transforming

In Environment I have:

Correct User/Pass (I logged in and out of Snowflake 3x to be sure it’s correct)
Schema: dbt_shull
Target Name: default

I get the following:

check failed:

dbt was unable to connect to the specified database.

The database returned the following error:

Database Error

290404 (08001): 404 Not Found: post BSD82187.snowflakecomputing.com:443/session/v1/login-request

I would appreciate some help on what’s going on.

2

The account in connection/profiles.yml needs to be the account identifier.

account: umtger-bsd82187

3

Hey dizzy, did you get this resolved? Like Matej said, make sure the account identifier is correct. I think an issue I ran into before was that it was using the wrong profile from the profiles.yml file. You can try passing the correct profile using the command line argument (with 2 dashes) –profile=profile_name

4

Yes, that was it.

The video, and the link to check for what to use was extremely confusing.

Thank you!