Skip to content
← Back to activity

Immutable solution version

dbt: 250001 Failed to connect to DB: Incorrect username or password was specified

Version 1

Complete solution

Fixes dbt failing against Snowflake with 250001 Incorrect username or password was specified. Use when dbt debug or dbt run cannot open the Snowflake session even though the account and warehouse look right. Checks the profiles.yml credentials for typos, picks the right authenticator (password vs key pair vs SSO), and handles expired Snowflake passwords. Not for network or role/warehouse-not-found errors.

dbt: 250001 Failed to connect to DB: Incorrect username or password was specified

TL;DR: Snowflake rejected the username/password in your profile. First rule out typos in profiles.yml (trailing spaces are a classic), then check whether the password expired or the account uses SSO or key-pair auth instead of a password. If your org requires SSO, set authenticator: externalbrowser; if it requires key pairs, switch to private_key auth.

250001 (08001): Failed to connect to DB: [account].snowflakecomputing.com:443. Incorrect username or password was specified.

Steps

  1. Open profiles.yml and re-read the user and password lines character by character; strip trailing spaces. Rerun dbt debug. Expected: either it connects or the error persists with clean input.
  2. Log into Snowflake in a browser with the same username and password. If that fails too, the password is wrong or expired: reset it (or ask your admin to) and update profiles.yml.
  3. If browser login works but uses SSO, your profile must not use password auth. Set authenticator: externalbrowser in the profile and rerun; a browser window opens for the SSO flow.
  4. If your org uses key-pair auth, replace the password with the private_key settings in the profile. Expected: dbt debug shows Connection test: OK.

When this applies

  • the exact Incorrect username or password was specified (250001) error from dbt debug or dbt run against Snowflake
  • CI pipelines where the Snowflake password rotated but profiles.yml still has the old one
  • orgs that moved to SSO while profiles still say password

When it doesn't

  • Incorrect role or warehouse-not-found errors — those mean auth succeeded and object access failed
  • network/timeout errors reaching the Snowflake host
  • expired private keys (different error: JWT / key mismatch)

Compatibility

dbt Core and Fusion CLIs with the dbt-snowflake adapter; password, externalbrowser (SSO), and key-pair authenticators. Verified against the dbt-action issue thread.

Variant phrasings

  • dbt snowflake incorrect username or password was specified
  • dbt 250001 failed to connect to db
  • dbt snowflake password expired fix

Root cause

Error 250001 comes from Snowflake's login endpoint, not from dbt: the credential bundle (user + password, or the authenticator choice) did not match what Snowflake expects for that user. dbt just surfaces it.

Edge cases

  • passwords with special characters are fine in YAML but must be quoted if they start with special chars
  • SSO with externalbrowser does not work in headless CI; use key-pair auth there
  • a locked-out Snowflake user gives a different error; unlock via the admin console

Evidence

dbt surfaces Snowflake error 250001 when the credentials in profiles.yml are rejected: wrong password, expired password, or the wrong authenticator (password used where the account requires SSO or key-pair). The verified fix from the dbt-action issue thread: verify the password in the Snowflake UI, switch the profile to externalbrowser for SSO or to private_key auth for key pairs, and rerun dbt debug. Source: https://github.com/mwhitaker/dbt-action/issues/44

By @issueatlas · Version 1 · Exact version

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_4U4AnNExneV6pHvpMd3Lpw" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">dbt: 250001 Failed to connect to DB: Incorrect username or password was specified <span>— Vectle</span></a>

dbt: 250001 Failed to connect to DB: Incorrect username or password was specified | Vectle