public static interface LoadConfiguration.Builder
Modifier and Type | Method and Description |
---|---|
LoadConfiguration |
build() |
LoadConfiguration.Builder |
setAutodetect(Boolean autodetect)
[Experimental] Sets automatic inference of the options and schema for CSV and JSON sources.
|
LoadConfiguration.Builder |
setClustering(Clustering clustering)
Sets the clustering specification for the destination table.
|
LoadConfiguration.Builder |
setCreateDisposition(JobInfo.CreateDisposition createDisposition)
Sets whether the job is allowed to create new tables.
|
LoadConfiguration.Builder |
setDecimalTargetTypes(List<String> decimalTargetTypes)
Defines the list of possible SQL data types to which the source decimal values are converted.
|
LoadConfiguration.Builder |
setDestinationEncryptionConfiguration(EncryptionConfiguration encryptionConfiguration) |
LoadConfiguration.Builder |
setDestinationTable(TableId destinationTable)
Sets the destination table to load the data into.
|
LoadConfiguration.Builder |
setFormatOptions(FormatOptions formatOptions)
Sets the source format, and possibly some parsing options, of the external data.
|
LoadConfiguration.Builder |
setIgnoreUnknownValues(Boolean ignoreUnknownValues)
Sets whether BigQuery should allow extra values that are not represented in the table schema.
|
LoadConfiguration.Builder |
setMaxBadRecords(Integer maxBadRecords)
Sets the maximum number of bad records that BigQuery can ignore when running the job.
|
LoadConfiguration.Builder |
setNullMarker(String nullMarker)
Sets the string that represents a null value in a CSV file.
|
LoadConfiguration.Builder |
setSchema(Schema schema)
Sets the schema for the destination table.
|
LoadConfiguration.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.
|
LoadConfiguration.Builder |
setTimePartitioning(TimePartitioning timePartitioning)
Sets the time partitioning specification for the destination table.
|
LoadConfiguration.Builder |
setUseAvroLogicalTypes(Boolean useAvroLogicalTypes)
If FormatOptions is set to AVRO, you can interpret logical types into their corresponding
types (such as TIMESTAMP) instead of only using their raw types (such as INTEGER).
|
LoadConfiguration.Builder |
setWriteDisposition(JobInfo.WriteDisposition writeDisposition)
Sets the action that should occur if the destination table already exists.
|
LoadConfiguration.Builder setDestinationTable(TableId destinationTable)
LoadConfiguration.Builder setDestinationEncryptionConfiguration(EncryptionConfiguration encryptionConfiguration)
LoadConfiguration.Builder setCreateDisposition(JobInfo.CreateDisposition createDisposition)
LoadConfiguration.Builder setWriteDisposition(JobInfo.WriteDisposition writeDisposition)
LoadConfiguration.Builder setFormatOptions(FormatOptions formatOptions)
CSV
, NEWLINE_DELIMITED_JSON
and DATASTORE_BACKUP
. If not
specified, CSV
format is assumed.
LoadConfiguration.Builder setNullMarker(String nullMarker)
STRING
and BYTE
. For
STRING
and BYTE
columns, BigQuery interprets the empty string as an empty
value.LoadConfiguration.Builder setMaxBadRecords(Integer maxBadRecords)
LoadConfiguration.Builder setSchema(Schema schema)
DATASTORE_BACKUP
format option).LoadConfiguration.Builder setIgnoreUnknownValues(Boolean ignoreUnknownValues)
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.LoadConfiguration.Builder setSchemaUpdateOptions(List<JobInfo.SchemaUpdateOption> schemaUpdateOptions)
LoadConfiguration.Builder setAutodetect(Boolean autodetect)
LoadConfiguration.Builder setTimePartitioning(TimePartitioning timePartitioning)
LoadConfiguration.Builder setClustering(Clustering clustering)
LoadConfiguration.Builder setUseAvroLogicalTypes(Boolean useAvroLogicalTypes)
null
.LoadConfiguration.Builder setDecimalTargetTypes(List<String> decimalTargetTypes)
decimalTargetTypes
- decimalTargetType or null
for noneLoadConfiguration build()
Copyright © 2023 Google LLC. All rights reserved.