com.google.cloud.bigquery

Class ExternalTableDefinition.Builder

java.lang.Object

com.google.cloud.bigquery.TableDefinition.Builder<ExternalTableDefinition,ExternalTableDefinition.Builder>

com.google.cloud.bigquery.ExternalTableDefinition.Builder

Enclosing class:

ExternalTableDefinition

public abstract static class ExternalTableDefinition.Builder
extends TableDefinition.Builder<ExternalTableDefinition,ExternalTableDefinition.Builder>

Constructor Summary

Constructors

Constructor and Description
Builder()

Method Summary

Modifier and Type	Method and Description
abstract ExternalTableDefinition	build() Creates an ExternalTableDefinition object.
abstract ExternalTableDefinition.Builder	setAutodetect(Boolean autodetect) [Experimental] Sets detection of schema and format options automatically.
abstract ExternalTableDefinition.Builder	setCompression(String compression) Sets compression type of the data source.
ExternalTableDefinition.Builder	setFormatOptions(FormatOptions formatOptions) Sets the source format, and possibly some parsing options, of the external data.
abstract ExternalTableDefinition.Builder	setIgnoreUnknownValues(Boolean ignoreUnknownValues) Sets whether BigQuery should allow extra values that are not represented in the table schema.
abstract ExternalTableDefinition.Builder	setMaxBadRecords(Integer maxBadRecords) Sets the maximum number of bad records that BigQuery can ignore when reading data.
abstract ExternalTableDefinition.Builder	setSchema(Schema schema) Sets the table schema.
ExternalTableDefinition.Builder	setSourceUris(List<String> sourceUris) Sets the fully-qualified URIs that point to your data in Google Cloud Storage (e.g.
abstract ExternalTableDefinition.Builder	setType(TableDefinition.Type type)

Methods inherited from class java.lang.Object

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

Constructor Detail

Builder

public Builder()

Method Detail

setSourceUris

public ExternalTableDefinition.Builder setSourceUris(List<String> sourceUris)

Sets the fully-qualified URIs that point to your data in Google Cloud Storage (e.g. gs://bucket/path). Each URI can contain one '*' wildcard character that must come after the bucket's name. Size limits related to load jobs apply to external data sources, plus an additional limit of 10 GB maximum size across all URIs.

For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table.

For Google Cloud Datastore backup URIs: Exactly one URI can be specified. Also, the '*' wildcard character is not allowed.

See Also:

Quota

setFormatOptions

public ExternalTableDefinition.Builder setFormatOptions(FormatOptions formatOptions)

Sets the source format, and possibly some parsing options, of the external data. Supported formats are CSV and NEWLINE_DELIMITED_JSON.

Source Format

setMaxBadRecords

public abstract ExternalTableDefinition.Builder setMaxBadRecords(Integer maxBadRecords)

Sets the maximum number of bad records that BigQuery can ignore when reading data. If the number of bad records exceeds this value, an invalid error is returned in the job result. The default value is 0, which requires that all records are valid.

setIgnoreUnknownValues

public abstract ExternalTableDefinition.Builder setIgnoreUnknownValues(Boolean ignoreUnknownValues)

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. The default value is false. The value set with setFormatOptions(FormatOptions) property determines what BigQuery treats as an extra value.

See Also:

Ignore Unknown Values

setCompression

public abstract ExternalTableDefinition.Builder setCompression(String compression)

Sets compression type of the data source. By default no compression is assumed.

See Also:

Compression

setAutodetect

public abstract ExternalTableDefinition.Builder setAutodetect(Boolean autodetect)

[Experimental] Sets detection of schema and format options automatically. Any option specified explicitly will be honored.

setType

public abstract ExternalTableDefinition.Builder setType(TableDefinition.Type type)

Specified by:

setType in class TableDefinition.Builder<ExternalTableDefinition,ExternalTableDefinition.Builder>

setSchema

public abstract ExternalTableDefinition.Builder setSchema(Schema schema)

Sets the table schema.

Specified by:

setSchema in class TableDefinition.Builder<ExternalTableDefinition,ExternalTableDefinition.Builder>

build

public abstract ExternalTableDefinition build()

Creates an ExternalTableDefinition object.

Specified by:

build in class TableDefinition.Builder<ExternalTableDefinition,ExternalTableDefinition.Builder>