https://prefect.io logo
l

lisa fang

07/19/2023, 6:27 PM
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?
1
s

Sean Williams

07/19/2023, 6:47 PM
In your
profiles.yml
file, have you tried setting
reuse_connections
and/or
client_session_keep_alive
to true?
l

lisa fang

07/19/2023, 7:20 PM
Latter is true and didn’t notice a difference. Will try the first one.
Not seeing a difference with that first setting added to my
profiles.yml
either.
s

Sean Williams

07/19/2023, 8:00 PM
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
l

lisa fang

07/19/2023, 8:48 PM
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.
1