Problem Note 71122: The Google BigQuery NUMERIC data type is read with a value of zero
 |  |  |  |  |
Using BULKUNLOAD with SAS/ACCESS® Interface to Google BigQuery might result in some values being read as 0.
This issue occurs when the Google BigQuery data type is NUMERIC, and you installed the hot fixes related to SAS Note 71031, "Performance improvements to SAS/ACCESS® Interface to Google BigQuery."
- SAS® 9.4M7 (TS1M7) and SAS/ACCESS Interface to Google BigQuery 9.42 K3N013
- SAS® 9.4M8 (TS1M8) and SAS/ACCESS Interface to Google BigQuery 9.43 M7Z006
SAS Technical Support recommends using READMODE=STORAGE (where this issue is not seen) as a workaround.
If using READMODE=STORAGE is not an option, the only other workarounds are as follows:
- Do not use BULKUNLOAD.
- Add a LIBNAME or the FETCH_NUMERIC_TYPE=NUMERIC data set option.
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.42 | 9.4 TS1M7 | ||
A 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#71122
When you use BULKUNLOAD with the BIGQUERY engine, columns that have a Google BigQuery data type of NUMERIC are read with a value of zero.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Access |
| Date Modified: | 2025-02-18 08:17:41 |
| Date Created: | 2025-02-07 08:13:50 |