Versions Compared

Old Version 13

changes.mady.by.user Morgan Mackeson-Ellis

Saved on

compared with

New Version 14

changes.mady.by.user Morgan Mackeson-Ellis

Saved on

Key

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

...

  • Snowflake ODBC driver version 3.10
  • SnowSQL version 1.4

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.

Examples: 

  • If using User DSN's then a Scheduler on the same machine running under 'Local System' will not have access to the DSN. Solution: configure a System DSN for the Scheduler service, or move the service to a specific windows user and configure a User DSN for the service user.
  • If the Scheduler is on a remote machine, repeat the DSN key-pair setup steps on the scheduler machine,
  • If also using SnowSQL then the same considerations above should be applied to SnowSQL authentication setup, or apply the WslPowershellCommon module workaround on each machine running RED or the RED Scheduler.


Snowflake Authentication Methods Supported by RED

...