Versions Compared

Key

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

...

This a guide to authenticating to Snowflake with RED, it covers how to configure RED with the different authentication types but does not go into detail of Snowflake setup steps. For advanced Snowflake setup, including ODBC DSN registry settings, please refer to Snowflake's documentation. 

This guide is based on these versions of Snowflake ODBC driver and SnowSQL, in earlier versions some options and settings may not be available or must be set using a different method, please refer to Snowflake documentation for your specific version.

...

  • Snowflake ODBC driver version 3.10
  • SnowSQL version 1.4

This guide is targeted at all versions of RED below 10.6.0.0, 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.  

Setup Tips

Since RED Scheduler can run on a different machine and/or under a different user it is important to make sure that the service user the RED Scheduler is running under has access to the ODBC DSN which has been configured and tested for a given authentication type. Each machine running RED or the RED Scheduler will need to be configured to suit the desired authentication type.

...

Info

Other Snowflake authentication methods may also work with RED by following similar configuration methods outlined in this guide.

In RED 10.6 we added Extensible Authentication which enables scriptable authentication workflows which can be configured in RED Connections and triggered on by at a configurable expiry timeinterval, please review review this section for more details.  

...