Test connection fails when QUOTED_IDENTIFIERS_IGNORE_CASE is set to true

Snowflake-Labs / sqltools-snowflake-driver

A Snowflake driver for the SQLTools VSCode extension.

MIT License

35 stars 15 forks source link

Test connection fails when QUOTED_IDENTIFIERS_IGNORE_CASE is set to true #10

Closed yadavsahil197 closed 3 years ago

yadavsahil197 commented 3 years ago

The driver fails to connect for cases where the QUOTED_IDENTIFIERS_IGNORE_CASE in the snowflake account/user is set to True. To handle all cases, we should set it to False for the session by adding this query ALTER SESSION SET QUOTED_IDENTIFIERS_IGNORE_CASE=FALSE;

koszti commented 3 years ago

fixed in v0.2.1 and released to vs marketplace. Now it should be available in your vscode to upgrade.