Snowflake ODBC connection with auth:externalbrowser fails

[MarcoPieters]

What is the bug or the crash?

When i try to make a Snowflake ODBC connection with auth:externalbrowser it fails at QGIS databaseconnection in menu new vectorlayer. The ODBC connection works fine in Excel. The username is in format firstname.lastname@company.com.

Steps to reproduce the issue

ODBC-64bits
User DNS:
name : snowflake
user: firstname.lastname@company.com
auth: externalbrowser

QGIS
click on Menuoption: Open Datasource manager -> Vector -> source type: Database
Data type : ODBC

connections edit:
name: snowflake_connection
Host: localhost
Database: snowflake

Authentication:
User name: firstname.lastname@company.com
Password: empty because of ODBC externalbrowser choise

When i click on "test Connection" i first get the external browser verification from the ODBC settings wich is alright.
_But the there is the error message: "Connection failed - Check settings and try again."
Extended error information: Unable to initialize ODBC connection to DSN for firstname.lastname@company.com@snowflake,

"It seems that the email in the username is not handled very well, and the extra 'at' sign confuses me. Also, the comma at the end seems odd."

Versions

QGIS version
3.38.2-Grenoble
QGIS code revision
130c432
Qt version
5.15.13
Python version
3.12.5
GDAL/OGR version
3.9.2
PROJ version
9.4.0
EPSG Registry database version
v11.004 (2024-02-24)
GEOS version
3.12.2-CAPI-1.18.2
SQLite version
3.45.1
PDAL version
2.6.3
PostgreSQL client version
16.2
SpatiaLite version
5.1.0
QWT version
6.2.0
QScintilla2 version
2.14.1
OS version
Windows 10 Version 2009

Active Python plugins
CityJSON-loader
0.8.1
StreetView
3.2
db_manager
0.1.20
grassprovider
2.12.99
MetaSearch
0.3.6
processing
2.12.99

Supported QGIS version

• I'm running a supported QGIS version according to the roadmap.

New profile

• I tried with a new QGIS profile

Additional context

No response

[sfc-gh-obielov]

Hey @MarcoPieters, Snowflake recently released a beta version of QGIS-Snowflake connector as a Python Plugin. Feel free to try it out: https://github.com/snowflakedb/qgis-snowflake-connector