Page History
| Table of Contents | ||
|---|---|---|
|
| Tip | ||
|---|---|---|
| ||
| This guide was written for all versions of RED below 10.6, while still applicable to RED 10.6+, in RED 10.6 we added Extensible Authentication which enables scriptable authentication workflows which can be configured in RED Connections and triggered at a configurable expiry interval, please review this section for more details. This feature provides complete control over the authentication process, adds secure storage of additional connection string tokens and allows for the creation of authentication workflows which are not otherwise handled by RED and/or vendor ODBC drivers directly. |
ODBC Key Pair Authentication
Follow Snowflake setup instructions here: Key-pair authentication and key-pair rotation | Snowflake Documentation
...
If using this form of authentication with RED it is recommended that the Snowflake Account Level Parameter to allow caching of the MFA token is enabled, this prevents the user having to keep entering a new TOTP each time a connection is made. Without this feature client MFA caching enabled RED UI connections to Snowflake would be unusable until RED supports oAuth style refresh workflows (planned for RED 10.6).practically unusable due to the frequency of MFA requests.
To allow MFA caching set this account parameter:
...
RED Connection Setup with Snowflake MFA
| Tip | ||
|---|---|---|
| ||
| In RED 10.6 we added Extensible Authentication which provides an example workflow for Snowflake MFA, please review this section for more details. |
RED 9 and RED 10 using Advanced Connect
...