search

Snowflake-Labs / sqltools-snowflake-driver

A Snowflake driver for the SQLTools VSCode extension.
MIT License
35 stars 15 forks source link

Browser Based SSO #30

Closed reachpons closed 3 years ago

reachpons commented 3 years ago

Thanks koszti for providing this great extension. My snowflake is enabled with SSO. When I try to use Browser Based SSO, I'm getting below error. Has anyone used this option successfully.

Below my connection details:

Connection name: Test-Connection Connection Group Test-Group Account: https://xxx-southeast-2.snowflakecomputing.com Authenticator - Browser Based SSO Username - email@domain.com Database- Default database Warehouse - Valid warehouse

[1616122522595] INFO (ext): EXECUTING COMMAND => sqltools.selectConnection [1616122522596] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1616122522596] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1616122522597] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1616122522597] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1616122522598] INFO (ls): REQUEST RECEIVED => connection/ConnectRequest [1616122522598] INFO (ls): Connection instance created for Snowflake. ns: "conn-manager" (node:12568) UnhandledPromiseRejectionWarning: Error: getaddrinfo ENOTFOUND https at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:66:26) (node:12568) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag --unhandled-rejections=strict (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 12)

reachpons commented 3 years ago

works now with xxx.ap-southeast-2 as account name. Not worked if I use full name.