UseStreamingInserts Parameter (Connect-GoogleBigQuery Cmdlet)CData Cmdlets 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.
Connect-GoogleBigQuery -UseStreamingInserts bool
When set to true, the cmdlet 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 cmdlet 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.