com.google.cloud.bigquery

Class WriteChannelConfiguration.Builder

java.lang.Object

com.google.cloud.bigquery.WriteChannelConfiguration.Builder

All Implemented Interfaces:

LoadConfiguration.Builder

Enclosing class:

WriteChannelConfiguration

public static final class WriteChannelConfiguration.Builder
extends Object
implements LoadConfiguration.Builder

Method Summary

Modifier and Type	Method and Description
WriteChannelConfiguration	build()
WriteChannelConfiguration.Builder	setAutodetect(Boolean autodetect) [Experimental] Sets automatic inference of the options and schema for CSV and JSON sources.
WriteChannelConfiguration.Builder	setCreateDisposition(JobInfo.CreateDisposition createDisposition) Sets whether the job is allowed to create new tables.
WriteChannelConfiguration.Builder	setDestinationTable(TableId destinationTable) Sets the destination table to load the data into.
WriteChannelConfiguration.Builder	setFormatOptions(FormatOptions formatOptions) Sets the source format, and possibly some parsing options, of the external data.
WriteChannelConfiguration.Builder	setIgnoreUnknownValues(Boolean ignoreUnknownValues) Sets whether BigQuery should allow extra values that are not represented in the table schema.
WriteChannelConfiguration.Builder	setMaxBadRecords(Integer maxBadRecords) Sets the maximum number of bad records that BigQuery can ignore when running the job.
WriteChannelConfiguration.Builder	setNullMarker(String nullMarker) Sets the string that represents a null value in a CSV file.
WriteChannelConfiguration.Builder	setSchema(Schema schema) Sets the schema for the destination table.
WriteChannelConfiguration.Builder	setSchemaUpdateOptions(List<JobInfo.SchemaUpdateOption> schemaUpdateOptions) [Experimental] Sets options allowing the schema of the destination table to be updated as a side effect of the load job.
WriteChannelConfiguration.Builder	setWriteDisposition(JobInfo.WriteDisposition writeDisposition) Sets the action that should occur if the destination table already exists.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

setDestinationTable

public WriteChannelConfiguration.Builder setDestinationTable(TableId destinationTable)

Description copied from interface: LoadConfiguration.Builder

Sets the destination table to load the data into.

Specified by:

setDestinationTable in interface LoadConfiguration.Builder

setCreateDisposition

public WriteChannelConfiguration.Builder setCreateDisposition(JobInfo.CreateDisposition createDisposition)

Description copied from interface: LoadConfiguration.Builder

Sets whether the job is allowed to create new tables.

Specified by:

setCreateDisposition in interface LoadConfiguration.Builder

See Also:

Create Disposition

setWriteDisposition

public WriteChannelConfiguration.Builder setWriteDisposition(JobInfo.WriteDisposition writeDisposition)

Description copied from interface: LoadConfiguration.Builder

Sets the action that should occur if the destination table already exists.

Specified by:

setWriteDisposition in interface LoadConfiguration.Builder

See Also:

Write Disposition

setFormatOptions

public WriteChannelConfiguration.Builder setFormatOptions(FormatOptions formatOptions)

Description copied from interface: LoadConfiguration.Builder

Sets the source format, and possibly some parsing options, of the external data. Supported formats are CSV, NEWLINE_DELIMITED_JSON and DATASTORE_BACKUP. If not specified, CSV format is assumed. Source Format

Specified by:

setFormatOptions in interface LoadConfiguration.Builder

setNullMarker

public WriteChannelConfiguration.Builder setNullMarker(String nullMarker)

Description copied from interface: LoadConfiguration.Builder

Sets the 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.

Specified by:

setNullMarker in interface LoadConfiguration.Builder

setMaxBadRecords

public WriteChannelConfiguration.Builder setMaxBadRecords(Integer maxBadRecords)

Description copied from interface: LoadConfiguration.Builder

Sets the maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. By default no bad record is ignored.

Specified by:

setMaxBadRecords in interface LoadConfiguration.Builder

setSchema

public WriteChannelConfiguration.Builder setSchema(Schema schema)

Description copied from interface: LoadConfiguration.Builder

Sets the schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from a Google Cloud Datastore backup (i.e. DATASTORE_BACKUP format option).

Specified by:

setSchema in interface LoadConfiguration.Builder

setIgnoreUnknownValues

public WriteChannelConfiguration.Builder setIgnoreUnknownValues(Boolean ignoreUnknownValues)

Description copied from interface: LoadConfiguration.Builder

Sets whether BigQuery should allow extra values that are not represented in the table schema. If true, the extra values are ignored. If false, records with extra columns are treated as bad records, and if there are too many bad records, an invalid error is returned in the job result. By default unknown values are not allowed.

Specified by:

setIgnoreUnknownValues in interface LoadConfiguration.Builder

setSchemaUpdateOptions

public WriteChannelConfiguration.Builder setSchemaUpdateOptions(List<JobInfo.SchemaUpdateOption> schemaUpdateOptions)

Description copied from interface: LoadConfiguration.Builder

[Experimental] Sets options allowing the schema of the destination table to be updated as a side effect of the load job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema.

Specified by:

setSchemaUpdateOptions in interface LoadConfiguration.Builder

setAutodetect

public WriteChannelConfiguration.Builder setAutodetect(Boolean autodetect)

Description copied from interface: LoadConfiguration.Builder

[Experimental] Sets automatic inference of the options and schema for CSV and JSON sources.

Specified by:

setAutodetect in interface LoadConfiguration.Builder

build

public WriteChannelConfiguration build()

Specified by:

build in interface LoadConfiguration.Builder