Versions Compared

Old Version 13

changes.mady.by.user Morgan Mackeson-Ellis

Saved on

compared with

New Version Current

changes.mady.by.user Morgan Mackeson-Ellis

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2


Tip

In Enablement Pack versions greater than the following, the use of SnowSQL* has been removed in favor of ODBC only, this change allows for a single point of authentication configuration for Snowflake and RED. 

  • RED 10.2+ EP Build 250904-1855 and higher
  • RED 9.0 EP Build 250911-1939 and higher

For earlier versions of RED, the EP, or for existing PowerShell scripts which you do not want to rebuild, consider

Consider

changing all RED SnowSQL calls to ODBC, to simplify authentication configuration, by using the method described here.

Info

*Note: Snowflake have deprecated SnowSQL in favor of Snowflake CLI, but RED only requires ODBC alone.

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.

...