public sealed class UploadCsvOptions : JobCreationOptionsReference documentation and code samples for the Google BigQuery v2 API class UploadCsvOptions.
Options for UploadCsv operations.
Namespace
Google.Cloud.BigQuery.V2Assembly
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 |
|
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 |
|