Versions Compared

Old Version 12

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.

...

  • authenticator = SNOWFLAKE_JWT

    • Set either in the snowsql.conf file or as a command line parameter.

    • Set via RED - can Can not be set in RED.

  • private-key-path = Path to private key file.

    • Set in the snowsql.conf file, as a command line parameter.

    • Set via RED - can Can not be set in RED.

  • private_key_passphrase = passphrase for protected private key file [required when private key is protected]

    • Set by environment variable only SNOWSQL_PRIVATE_KEY_PASSPHRASE

    • Set via RED - can Can not be set in RED OOTB, but can be set via HSL command-line hack.

  • username = Snowflake User.

    • Set either in the snowsql.conf file, as a command line parameter or environment variable.

      • RED currently uses the environment variable method.

    • Set via RED - you can use the normal “Username” field in your connections.

...

Add these snowsql.conf entries at the default level (or under a named connection):

Code Block
languagetext
accountname = my_org 
username = my_user_name 
authenticator = snowflake_jwt 
private_key_path = C:\Users\Administrator\snowflake_rsa_key.p8

...