Hello, I used the <Prefect+dbt> code examples to d...
# prefect-getting-started
l
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
In your
profiles.yml
file, have you tried setting
reuse_connections
and/or
client_session_keep_alive
to true?
l
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
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
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