Problem Note 67539: SAS® might display an error when you attempt to delete a Google BigQuery view
 |  |  |  |  |
The DATASETS and DELETE procedures might fail to delete a Google BigQuery view, and an error that is similar to the following appears:
ERROR: CLI execute error: Error: googleapi: Error 400: Cannot drop gcp-project:data-set.view-name which has type VIEW. A table was expected., invalid
The only workaround is to use an explicit SQL query. Here is an example:
proc sql ;
connect to bigquery (connection-options) ;
execute by dbms (drop view view-name) ;
quit ;
connect to bigquery (connection-options) ;
execute by dbms (drop view view-name) ;
quit ;
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 |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K2L.html#67539A 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#67539
PROC DATASETS and PROC DELETE might display an error when attempting to delete a Google BigQuery view. The message is "Error 400: Cannot drop gcp-project:data-set.view-name which has type view. A table was expected."
| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> Procedures ==> DATASETS SAS Reference ==> Procedures ==> DELETE SAS Reference ==> Procedures ==> SQL |
| Date Modified: | 2021-04-13 10:29:34 |
| Date Created: | 2021-03-03 05:56:43 |