Hello, I used the Prefect+dbt code examples to deploy a flow that runs a dbt project in Snowflake. My Snowflake profile uses SSO/externalbrowser to log in and it’s started to prompt me to log in constantly, like twice before each dbt model is run. I lowered the number of threads in my profile but this did not seem to help. This does not happen when I run dbt normally without Prefect. Wondering if there is some setting or somewhere this is controlled?

In your

profiles.yml

file, have you tried setting

reuse_connections

and/or

client_session_keep_alive

to true?

Latter is true and didn’t notice a difference. Will try the first one.

Hmm. I'm not sure why the behavior would be different. If your org allows for it, I think it might be worth trying a different authentication method that doesn't require a browser

Yeah, I’m just doing this for a local test. I’m not actually sure what I changed but I went into a new virtual environment and it seems to have stopped.