Versions Compared

Old Version 22

changes.mady.by.user Morgan Mackeson-Ellis

Saved on

compared with

New Version 23

changes.mady.by.user Morgan Mackeson-Ellis

Saved on

Key

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

...

  • All required connection attributes need to be set in snowsql.conf file, SnowSQL command line parameters and environment variables.

  • RED Snowflake PowerShell Template Limitations

    • RED PowerShell scripts set SnowSQL environment variables but only cater for a limited set covering the requirements for user/pwd authentication.

    • If using a SnowSQL authentication method outside of user/pwd then those required settings must be specified in your snowsql.conf and any required password set as the appropriate environment variable.

    • RED does not provide a way to dynamically alter the command arguments for SnowSQL this means:

      • Only the default snowsql.conf can be used, since we can’t specify the SnowSQL connection name nor allow setting a different snowsql.conf path.

      • Therefore each Windows user would set up their own snowsql.conf file.

    • There is a 128 char limit on the Password field length so PAT’s and other long Tokens can’t be stored in the metadata (limit does not apply to RED connections using Advanced Connect, nor in RED 9.0.2.3+ Legacy Connect).