Problem Note 70687: Generating a list of Snowflake tables might be done at the account level and not the database or schema level
 |  |  |  |  |
Trying to display a list of Snowflake tables is often accomplished via the Snowflake SHOW command. However, the SHOW command might not be scoped to the database or schema level when the following are true:
- You are using SAS/ACCESS® Interface to Snowflake.
- You are using a LIBNAME statement to connect to Snowflake.
- You make actions such as the DATASETS procedure, the CONTENTS procedure with DATA=libref._all_, expanding the libref, trying to register tables using SAS® Management Console, using some of the dictionary tables, and so on.
- The database specified using the DATABASE= option or the schema specified using the SCHEMA= option contains an underscore.
The issue occurs because the underscore character is not being properly escaped, so a wider search for tables occurs, which affects performance. There is no workaround for this issue.
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 2024.02 | Viya | Viya |
| Microsoft® Windows® for x64 | V.03.04 | Viya | ||||
A fix for this issue for SAS/ACCESS Interface to Snowflake 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/L9B.html#70687| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-03-12 12:40:31 |
| Date Created: | 2024-03-04 16:27:04 |