Class CreateLoadJobOptions (3.1.0)

public sealed class CreateLoadJobOptions : JobCreationOptions

Options for CreateLoadJob operations.

Inheritance

Object > JobCreationOptions > CreateLoadJobOptions

Inherited Members

JobCreationOptions.ProjectId

JobCreationOptions.JobIdPrefix

JobCreationOptions.JobId

JobCreationOptions.JobLocation

JobCreationOptions.Labels

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Object.ToString()

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
Type	Description
`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
Type	Description
`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
Type	Description
`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
Type	Description
`Nullable<CreateDisposition>`

DestinationEncryptionConfiguration

public EncryptionConfiguration DestinationEncryptionConfiguration { get; set; }

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

Property Value
Type	Description
`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
Type	Description
`Nullable<SchemaUpdateOption>`

FieldDelimiter

public string FieldDelimiter { get; set; }

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

Property Value
Type	Description
`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
Type	Description
`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
Type	Description
`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
Type	Description
`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
Type	Description
`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
Type	Description
`String`

SkipLeadingRows

public int? SkipLeadingRows { get; set; }

The number of rows to skip, usually for headers.

Property Value
Type	Description
`Nullable<Int32>`

SourceFormat

public FileFormat? SourceFormat { get; set; }

The format of the source files.

Property Value
Type	Description
`Nullable<FileFormat>`

TimePartitioning

public TimePartitioning TimePartitioning { get; set; }

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

Property Value
Type	Description
`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
Type	Description
`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
Type	Description
`Nullable<WriteDisposition>`