dbt-labs / dbt-snowflake

dbt-snowflake contains all of the code enabling dbt to work with Snowflake
https://getdbt.com
Apache License 2.0
296 stars 176 forks source link

[BUG] 'str' object has no attribute 'get' with externalbrowser authentication #1249

Open javierpe27 opened 1 week ago

javierpe27 commented 1 week ago

Is this a new bug in dbt-snowflake?

Current Behavior

Hello, I am facing an issue, all of a sudden i cannot run my dbt models on snowflake using dbt-snowflake 1.8.3 I keep getting this error. I first thought that the profiles file was the issue but i have been using the same profile for months so it cannot be, I use externalbrowser authentication with sso but it never gets to even open the browser, the profiles file is also being read from the right path when doing dbt debug any idea?

Dbt run:

16:41:59 Running with dbt=1.8.8

16:41:59 Registered adapter: snowflake=1.8.3

16:42:00 Unable to do partial parsing because profile has changed

16:42:02 Found 26 models, 1 seed, 10 sources, 749 macros

16:42:02

16:42:02

16:42:02 Finished running in 0 hours 0 minutes and 0.02 seconds (0.02s).

16:42:02 Encountered an error:

Runtime Error

Database error while listing schemas in database "T"

Database Error

'str' object has no attribute 'get'

Expected Behavior

Open the browser and login, however the browser is not being opened

Steps To Reproduce

OS: windows 10 with Wsl dbt=1.8.8 adapter: snowflake=1.8.3 Python:3.10

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-snowflake:

Additional Context

No response

amychen1776 commented 3 days ago

@javierpe27 did you make any code changes before this started to fail?

javierpe27 commented 3 days ago

Hi @amychen1776 No change, I pull the code directly from the repo and it works for my colleagues, so it seems it is a dbt specific error in my machine. I tried uninstalling and installing again but it didn't solve it.

amychen1776 commented 2 days ago

@javierpe27 Could you try creating a new valid profiles.yml and pointing dbt to it? Just in case there is something related because your error message also calls out that the profiles.yml might have changed.

Also are you on the same version of Windows as your coworker?

colin-rogers-dbt commented 18 hours ago

@javierpe27 can you run the following command and share the output: dbt debug --connection log-level debug

michael-urrutia commented 11 hours ago

Have you tried upgrading to the latest version of dbt-snowflake, 1.8.4 to try and reproduce?

AmiriMc commented 11 hours ago

Have you tried upgrading to the latest version of dbt-snowflake, 1.8.4 to try and reproduce?

Me and my co-worker are using 1.8.4 and we're having the same issue when trying to connect via SSO.

javierpe27 commented 2 hours ago

Hi @michael-urrutia yes i just updated to 1.8.4 and i get the same error