Class CreateLoadJobOptions (3.1.0)

public sealed class CreateLoadJobOptions : JobCreationOptions

Options for CreateLoadJob operations.

Inheritance

Object > JobCreationOptions > CreateLoadJobOptions

Namespace

Google.Cloud.BigQuery.V2

Assembly

Google.Cloud.BigQuery.V2.dll

Properties

AllowJaggedRows

public bool? AllowJaggedRows { get; set; }

Whether or not to accept rows missing trailing optional columns. If not set, this is effectively false.

Property Value
TypeDescription
Nullable<Boolean>

AllowQuotedNewlines

public bool? AllowQuotedNewlines { get; set; }

Indicates if quoted data sections can contain newline characters. If not set, this is effectively false.

Property Value
TypeDescription
Nullable<Boolean>

Autodetect

public bool? Autodetect { get; set; }

Specifies whether or not the options and schema for CSV and JSON sources should automatically be inferred.

Property Value
TypeDescription
Nullable<Boolean>

CreateDisposition

public CreateDisposition? CreateDisposition { get; set; }

Specifies whether the operation is allowed to create new tables. If not set, this is effectively CreateIfNeeded.

Property Value
TypeDescription
Nullable<CreateDisposition>

DestinationEncryptionConfiguration

public EncryptionConfiguration DestinationEncryptionConfiguration { get; set; }

The encryption configuration to apply to the destination table, if any.

Property Value
TypeDescription
Google.Apis.Bigquery.v2.Data.EncryptionConfiguration

DestinationSchemaUpdateOptions

public SchemaUpdateOption? DestinationSchemaUpdateOptions { get; set; }

Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when WriteDisposition is WriteAppend; when WriteDisposition is WriteTruncate and the destination table is a partition of a table, specified by partition decorators. SchemaUpdateOption is marked with the FlagsAttribute so several flags can be specified.

Property Value
TypeDescription
Nullable<SchemaUpdateOption>

FieldDelimiter

public string FieldDelimiter { get; set; }

The delimiter between fields in the data. If not set, a comma (,) is used.

Property Value
TypeDescription
String

IgnoreUnknownValues

public bool? IgnoreUnknownValues { get; set; }

Whether or not to accept rows with extra values that are not represented in the table schema. If not set, this is effectively false.

Property Value
TypeDescription
Nullable<Boolean>

MaxBadRecords

public int? MaxBadRecords { get; set; }

The maximum number of bad records that are ignored before the overall job fails. If not set, this is effectively 0.

Property Value
TypeDescription
Nullable<Int32>

NullMarker

public string NullMarker { get; set; }

Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.

Property Value
TypeDescription
String

ProjectionFields

public IList<string> ProjectionFields { get; set; }

If sourceFormat is set to DatastoreBackup, indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.

Property Value
TypeDescription
IList<String>

Quote

public string Quote { get; set; }

The value used to quote data sections in a CSV file. If not set, a double quote (") is used.

Property Value
TypeDescription
String

SkipLeadingRows

public int? SkipLeadingRows { get; set; }

The number of rows to skip, usually for headers.

Property Value
TypeDescription
Nullable<Int32>

SourceFormat

public FileFormat? SourceFormat { get; set; }

The format of the source files.

Property Value
TypeDescription
Nullable<FileFormat>

TimePartitioning

public TimePartitioning TimePartitioning { get; set; }

The time partitioning to apply, if any. See TimePartition to create instances of TimePartitioning.

Property Value
TypeDescription
Google.Apis.Bigquery.v2.Data.TimePartitioning

UseAvroLogicalTypes

public bool? UseAvroLogicalTypes { get; set; }

For Avro sources, this indicates whether to enable interpreting logical types into their corresponding types (ie. TIMESTAMP), instead of only using their raw types (ie. INTEGER). If unset, the server default will be used.

Property Value
TypeDescription
Nullable<Boolean>

WriteDisposition

public WriteDisposition? WriteDisposition { get; set; }

Specifies the behavior if the destination table exists and is non-empty. If not set, this is effectively WriteAppend.

Property Value
TypeDescription
Nullable<WriteDisposition>