Problem Note 67750: Inserting data into a Google BigQuery table using the FEDSQL procedure might result in errors
 |  |  |  |  |
When you use the FEDSQL procedure and it involves inserting data into a Google BigQuery table, you might receive an error. Here are some of the errors that have been encountered due to this issue:
{Location: "ID"; Message: "no such field."; Reason: "invalid"})
The issue occurs when the data being inserted contains a backslash (\) and the SCANSTRINGCOLUMNS=YES option is specified.
The workaround is to use SCANSTRINGCOLUMNS=NO.
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.41 | 9.43 | 9.4 TS1M6 | 9.4 TS1M8 |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | 2020.1.1 | 2020.1.4 | Viya | Viya |
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#67750A 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#67750| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-04-21 16:24:30 |
| Date Created: | 2021-04-08 14:05:54 |