Usage Note 69649: The OAuth token is truncated when you use it with SAS/ACCESS® Interface to Snowflake and "ERROR: CLI error trying to establish connection" is returned
 |  |  |  |  |
Although the SAS/ACCESS Interface to Snowflake engine does not directly support the OAuth token authentication method, it is still possible to use this method by supplying the token with the CONOPTS= LIBNAME option. However, due to the length of the token, the string is truncated. This truncation causes an invalid token to be used for authentication.
libname mylib snow server=server_name database=database schema=schema conopts="authenticator=oauth; token=&mytoken;";
Here is an example error that occurs in this scenario:
There is no workaround to dynamically supply the token in the CONOPTS LIBNAME option. You can avoid the truncation if the token is supplied as a DSN option, although this method not practical. It is also important to note that the token truncation occurs due to the driver manager that is used even if it is correctly supplied by SAS. The UnixODBC driver manager has a known issue where it also truncates an OAuth token string. Consult your specific ODBC driver manager documentation to confirm support for OAuth.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Snowflake | Linux for x64 | 9.4 | 9.4 TS1M6 | ||