dbt-core: Indefinite Snowflake auth loop when using browser authentication

Describe the bug

We encounter indefinite auth loop while running dbt with browser auth enabled

Steps To Reproduce

Install dbt 0.17.2 and run anything on Snowflake

Expected behavior

Expected two auth requests in case of MFA and dbt proceeding to transform. (non-MFA logins fail into the loop too)

Screenshots and log output

(dbt-transformations) <wiped out>@<wiped out> dbt-transformations % dbt run --models <wiped out>
Running with dbt=0.17.2
Found 129 models, 135 tests, 3 snapshots, 0 analyses, 140 macros, 0 operations, 1 seed file, 53 sources

Initiating login request with your identity provider. A browser window should have opened for you to complete the login. If you can't see it, check existing browser windows, or your OS settings. Press CTRL+C to abort and try again...
Initiating login request with your identity provider. A browser window should have opened for you to complete the login. If you can't see it, check existing browser windows, or your OS settings. Press CTRL+C to abort and try again...
Initiating login request with your identity provider. A browser window should have opened for you to complete the login. If you can't see it, check existing browser windows, or your OS settings. Press CTRL+C to abort and try again...
Initiating login request with your identity provider. A browser window should have opened for you to complete the login. If you can't see it, check existing browser windows, or your OS settings. Press CTRL+C to abort and try again...
Initiating login request with your identity provider. A browser window should have opened for you to complete the login. If you can't see it, check existing browser windows, or your OS settings. Press CTRL+C to abort and try again...
^C^C^Cctrl-c

System information

Which database are you using dbt with?

postgres
redshift
bigquery
snowflake
other (specify: ____________)

The output of dbt --version:

installed version: 0.17.2
   latest version: 0.17.2

Up to date!

Plugins:
  - bigquery: 0.17.2
  - snowflake: 0.17.2
  - redshift: 0.17.2
  - postgres: 0.17.2

The operating system you’re using: MacOS 10.15.5 (19F101)

The output of python --version: Python 3.7.7

Additional context

reverting dbt to 0.17.1 fixed the issue

About this issue

Original URL
State: closed
Created 4 years ago
Reactions: 1
Comments: 24 (12 by maintainers)

Most upvoted comments

@beckjake we have this issue as well (appeared when upgrading from 0.17.2 to 0.18.0). We’re running okta, snowflake and a variety of pc and mac configs.

We first changed alter account set allow_id_token = true, but that did not help. pip install keyring, however, seems to fix the issue!

thillerdal on Sep 16, 2020

Yes, I am using the latest version of all three. But it might be still related to the connector and has nothing to do with dbt. See https://github.com/snowflakedb/snowflake-connector-python/issues/349 WDYT Jeremy? 😃

feluelle on Oct 1, 2021

pip install keyring fixed the issue.

tonyqiu2020 on Sep 16, 2020