Page History
...
- dsn=$DSN$;uid=$USER$;pwd=$PASSWORD$$AUTHTKN_1$;passcodeInPassword=on;
...
ws_auth Snowflake-KeyPair
Auth Script Command =
| Code Block | ||
|---|---|---|
| ||
PowerShell -ExecutionPolicy bypass -f "c:\temp\ws_auth\ws_auth.ps1" -AuthType "Snowflake-KeyPair" -LogLevel "DEBUG" |
When executed by RED's authentication process 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.
NOTE: Key-Pair auth would not necessarily require a pop-up dialog at all, this is just provided as another example of how use the scripted authentication feature and how the new Auth Token fields work with connection strings. To actually use Key-Pair auth you can simply leave the Auth Script Command blank and use the Auth Token fields directly from the RED UI.
This mode should be used in conjunction with a connection string in your Snowflake connection set to:
- dsn=$DSN$;uid=$USER$;authenticator=SNOWFLAKE_JWT;priv_key_file_pwd=$PASSWORD$;priv_key_file=$AUTHTKN_1$;
