Problem Note 69766: Trying to run one of the Base SAS® procedures against a Snowflake table might return the message "ERROR: Requested function not supported"
 |  |  |  |  |
Running one of the Base SAS procedures that is enabled for in-database processing against a Snowflake table might result in the following error:
The error is an informational message to the user that the summarization is not being passed to the database. Instead of failing, the procedure should still work; but, instead SAS is reading the data from the Snowflake table and doing the processing. This behavior might result in slower performance than if the summarization had been done by the database.
The error might occur when the LIBNAME statement contains the ROLE= or WAREHOUSE= option and you use one of the following procedures:
- FREQ
- MEANS/SUMMARY
- REPORT
- SORT (NODUPKEY)
- REPORT
To work around the issue, you can do one of the following:
- Specify the ROLE or WAREHOUSE option in the CONOPTS= LIBNAME option.
- Grant the user's default role to PUBLIC.
- Add the ROLE or WAREHOUSE option to the DSN in the odbc.ini file.
See SAS Note 67487 for similar issue with the DATABASE= option, SAS NOTE 70478 for an issue with the ROLE= option, and SAS NOTE 70479 for an issue with the OKTA authentication.
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 | Microsoft® Windows® for x64 | 9.4 TS1M6 | |||
| Linux for x64 | 9.4 TS1M6 | |||||
| SAS System | SAS/ACCESS Interface to Snowflake (on SAS Viya) | Linux for x64 | V.03.04 | Stable 2023.01 | Viya | Viya platform |