Knowledge Article View - Customer Support

When you read in a Google BigQuery table, incorrect data might be returned when the following is true:

One of the string columns contains a special character, such as á, é, ã, õ, or Ó.
The BULKUNLOAD=YES option is included in the LIBNAME statement, the CONNECT TO statement, or as a data set option.

If the SCANSTRINGCOLUMNS=YES option is also included, the following warning might occur in addition to the incorrect data:

Warning: At least one column was truncated during UNLOAD read operation.

The workaround is to use the READ_MODE=STORAGE option in the LIBNAME statement, the CONNECT TO statement or as a data set option instead.

Reading in a BigQuery table using BULKUNLOAD might result in incorrect values