Versions Compared

Key

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

...

Parameters: 

  • AuthType - from:"Snowflake-MFA", "Snowflake-KeyPair", "Test-mode" [Default if not specified]

  • LogLevel - from:  "DEBUG", "INFO", "WARN", "ERROR", "FATAL" - Defaults to INFO

Logging:

This script produces logging based on the LogLevel setting, the log file will be created in the current user's temp directory with the withthe name 'ws_auth.log'. This location can be found in Windows by typing %TEMP% in an explorer window.

Example script commands


Note
LogLevel "DEBUG" will print the script environment variables to the log file ws_auth.log
This may expose passwords in plaint text therefore DEBUG should not be set in production.
Tip
1- The script path in these commands should reflect the path where you unpacked the ws_auth.zip file.
2- Ensure you also set an initial non-zero value for the Auth Expires After setting.
3- NOTE: You can not currently change a connection string via a Profile update,
therefore connection string is non-editable in these Auth UI's.

...

Code Block
languagepowershell
titleAuth Script Command
PowerShell -ExecutionPolicy bypass -f "c:\temp\ws_auth\ws_auth.ps1" -AuthType "Test-mode" -LogLevel    "DEBUG"

When executed by RED's authentication process this mode produces a dialog which provides the ability to change all fields except Auth Configuration JSON.


...

Code Block
languagepowershell
titleAuth Script Command
PowerShell -ExecutionPolicy bypass -f "c:\temp\ws_auth\ws_auth.ps1" -AuthType "Snowflake-MFA" -LogLevel    "DEBUG"

This mode produces a dialog which provides the ability to set a TOPT passcode and uses the Test ODBC functionality to establish an initial connection.

...

Code Block
languagepowershell
titleAuth Script Command
PowerShell -ExecutionPolicy bypass -f "c:\temp\ws_auth\ws_auth.ps1" -AuthType "Snowflake-KeyPair" -LogLevel    "DEBUG"

This mode produces a dialog which provides the ability to set a Key-Pair attributes and uses the 'Test on exit' functionality to establish an initial connection. 

...