public sealed class CreateLoadJobOptions : JobCreationOptionsReference documentation and code samples for the Google BigQuery v2 API class CreateLoadJobOptions.
Options for CreateLoadJob 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 | |
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 |
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 | |
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 |
bool | |
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. 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 |
IListstring | |
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 | |
SourceFormat
public FileFormat? SourceFormat { get; set; }The format of the source files.
| Property Value | |
|---|---|
| Type | Description |
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 |
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 |
bool | |
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 |
WriteDisposition | |