Search code examples
excelauthenticationodbcsnowflake-cloud-data-platform

Openning too many windows to authenticate


When I connect to snowflake from Excel using odbc, it opens too many windows to authenticate. To load a simple table, over 20 authentication windows opened till it finally showed the data. I believe it should authenticate only once and not for every small transaction?


Solution

  • Fixed now. It was due to a setting on Snowflake account to set allow_id_token = true :)