Google BigQuery v2 API - Class UploadCsvOptions (3.9.0)

public sealed class UploadCsvOptions : JobCreationOptions

Reference documentation and code samples for the Google BigQuery v2 API class UploadCsvOptions.

Options for UploadCsv operations.

Inheritance

object > JobCreationOptions > UploadCsvOptions

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
bool

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
bool

AllowTrailingColumns

public bool? AllowTrailingColumns { get; set; }

Whether or not to accept rows with more columns than are specified in the schema. If not set, this is effectively false.

Property Value
Type Description
bool

Autodetect

public bool? Autodetect { get; set; }

Specifies whether or not the options (including schema) should automatically be inferred. If not set, this is effectively false.

Property Value
Type Description
bool

ConfigurationModifier

public Action<JobConfigurationLoad> ConfigurationModifier { get; set; }

Optional action to perform after preparing the request. If this property is non-null, the JobConfigurationLoad used for a request will be passed to the delegate before the request is executed. This allows for fine-grained modifications which aren't otherwise directly supported by the properties in this options type.

Property Value
Type Description
ActionJobConfigurationLoad
Remarks

Prefer the properties on this type over this modifier to prepare the request. Only use this modifier to configure aspects for which there are no properties available. This modifier is applied to the request after all properties on this type have been applied. The delegate is only called once per operation, even if the request is automatically retried.

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
CreateDisposition

DestinationEncryptionConfiguration

public EncryptionConfiguration DestinationEncryptionConfiguration { get; set; }

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

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

Encoding

public string Encoding { get; set; }

The character encoding of the data. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the Quote and FieldDelimiter properties. See https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationLoad.FIELDS.encoding for more details.

Property Value
Type Description
string

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

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
int

NullMarker

public string NullMarker { get; set; }

Specifies a string that represents a null value in a CSV file. If not set, this is effectively the empty string.

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

TimePartitioning

public TimePartitioning TimePartitioning { get; set; }

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

Property Value
Type Description
TimePartitioning

WriteDisposition

public WriteDisposition? WriteDisposition { get; set; }

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

Property Value
Type Description
WriteDisposition