Problem Note 67983: Using the DATASETS procedure to delete a Google BigQuery view might result in a "table or view not found" error
 |  |  |  |  |
Trying to delete a Google BigQuery view might result in an error when the following is true:
- You are using the DATASETS procedure.
- You used USER as the libref in the LIBNAME statement for the BigQuery database.
The error might look similar to the following:
ERROR: CLI execute error: Base table or view not found
The workaround is to use explicit pass-through to drop the view.
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 Google BigQuery | Linux for x64 | 9.4 | 9.43 | 9.4 TS1M6 | 9.4 TS1M8 |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.04 | 2021.1.1 | Viya | Viya |
A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H5A.html#67983| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-06-07 14:47:30 |
| Date Created: | 2021-06-01 12:43:25 |