public sealed class UploadCsvOptions : JobCreationOptions
Reference 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 |
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 |