Inserting data into a Google BigQuery table might result in the following error:

The error has been observed when the following are true:

• You use SAS/ACCESS^® Interface to JDBC to write data to Google BigQuery.
• Your LIBNAME statement uses the BULKLOAD=YES table option. YES is the default value for this option. However, see Bulk Loading for JDBC.
• You use a Magnitude Simba driver that supports batch updates.
• The data type of the column that is being inserted is INTEGER.

To check whether your Java Database Connectivity (JDBC) driver supports batch updates, run a SASTRACE system option with your LIBNAME statement. Here is an example:

Check the log to see whether it contains a reference to supportsBatchUpdates. If it is set to TRUE, then the BULKLOAD option is supported by your driver. Here is an example:

Simba supplies the JDBC driver for Google BigQuery as a ZIP archive in this format: SimbaBigQueryJDBC42-[version-number].zip.

SAS has found that version 1.2.0.1000 of this driver does not support batch updates, but version 1.2.21.1025 does support batch updates.

The only workaround is to set the BULKLOAD=NO option in your LIBNAME statement. 

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to JDBC 9.41 is available at: