Page History
...
Migrate RED SnowSQL calls to Snowflake ODBC
| Info |
|---|
When WhereScape originally wrote the PowerShell 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. Now all the features that RED utilized SnowSQL for can be performed through the Snowflake ODBC driver directly. |
Since all RED PowerShell Templates produce scripts which import the common module ‘WslPowershellCommon’ there is opportunity to change the behavior of all existing scripts such that calls to SnowSQL are instead converted to calls via ODBC, thus eliminating the need to configure authentication aspects in both SnowSQL and ODBC.
...