CData Excel Add-In for Google BigQuery 2019 - Online Help
Questions / Feedback?

Use Streaming Inserts

CData Excel Add-In for Google BigQuery 2019 - Build 19.0.7354

Specifies whether to use streaming or DML statements when inserting data. By default, streaming inserts are used.

Data Type

bool

Default Value

true

Remarks

When set to true, the add-in will use streaming inserts to upload data. Streaming inserts allow for more data to be inserted in a single request and are generally faster. However, streaming inserts may lose data in some cases, such as if schema information is changed while the insert occurs. Also, data which is being streamed may be unavailable for a time while Google BigQuery commits data to the table.

When set to false, the add-in will use Standard SQL statements to do inserts. These requests will not drop data if the insert succeeds and allow your data to be accessed immediately. However, it is slower than streaming inserts and allows you to enter less data per day than if the data were streamed.

This has no effect when UseLegacySQL is true, because legacy SQL will always use streaming inserts.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0