search

evidence-dev / evidence

Business intelligence as code: build fast, interactive data visualizations in pure SQL and markdown
https://evidence.dev
MIT License
3.44k stars 167 forks source link

Snowflake auth sometimes open a new tab for every source query #1894

Open ItsMeBrianD opened 1 month ago

patricktrainer commented 1 month ago

I believe this is actually a snowflake thing when using browser based auth.

MFA token caching can help to reduce the number of prompts that must be acknowledged while connecting and authenticating to Snowflake, especially when multiple connection attempts are made within a relatively short time interval.

setting the param ALTER ACCOUNT SET ALLOW_CLIENT_MFA_CACHING = TRUE; should do the trick 👍