Class InsertOptions (2.3.0) 

public sealed class InsertOptions

Options for Insert operations.

Inheritance

Object > InsertOptions

Namespace

Google.Cloud.BigQuery.V2

Assembly

Google.Cloud.BigQuery.V2.dll

Properties

AllowEmptyInsertIds

public bool AllowEmptyInsertIds { get; set; }

When true allows InsertId to be unspecified. This in turns allows for faster inserts, at the expense of possible record duplication if the operation needs to be retried. See https://cloud.google.com/bigquery/quotas#streaming_inserts for more information. The default value is false.

Property Value
TypeDescription
Boolean

AllowUnknownFields

public bool? AllowUnknownFields { get; set; }

Whether or not to accept rows with fields that are not specified in the schema, ignoring the extra fields. If not set, this is effectively false.

Property Value
TypeDescription
Nullable<Boolean>

SkipInvalidRows

public bool? SkipInvalidRows { get; set; }

Insert all valid rows of a request, even if invalid rows exist. If false, the entire request will fail if any invalid rows exist. If not set, this is effectively false. This property is unset by default.

Property Value
TypeDescription
Nullable<Boolean>

SuppressInsertErrors

public bool SuppressInsertErrors { get; set; }

If true, insert errors don't lead to an exception. This property has no effect on which rows are inserted and which are not. The default value is false.

Property Value
TypeDescription
Boolean

TemplateSuffix

public string TemplateSuffix { get; set; }

If specified, treats the destination table as a base template, and inserts the rows into an instance table named "{destination}{templateSuffix}". BigQuery will manage creation of the instance table, using the schema of the base template table. See https://cloud.google.com/bigquery/streaming-data-into-bigquery#template-tables for considerations when working with templates tables.

Property Value
TypeDescription
String