Page History
...
SnowSQL Connections - both Legacy and Advanced Connect
| Info |
|---|
| Note: Snowflake have deprecated SnowSQL in favor of Snowflake CLI |
| Info |
|---|
| Background: When WhereScape originally wrote the templates for Snowflake the Snowflake ODBC driver had limited functionality so some of the operations required for loading, such as uploading files to Snowflake, were only available via SnowSQL. Later when WhereScape developed the Python based templates the newer Snowflake ODBC driver was able to perform all operations we required so the Python templates used ODBC exclusively. It is possible via a small code change in the WhereScape PowerShell common module to convert calls to snowsql into ODBC allowing existing PowerShell RED host scripts to connect to Snowflake with ODBC exclusively. |
Affects RED Template Type: PowerShell only
...