publicfinalclass LoadJobConfigurationextendsJobConfigurationimplementsLoadConfiguration
Google BigQuery load job configuration. A load job loads data from one of several formats into a
table. Data is provided as URIs that point to objects in Google Cloud Storage. Load job
configurations have JobConfiguration.Type#LOAD type.
Static Methods
builder(TableId destinationTable, String sourceUri)
publicstaticLoadJobConfiguration.Builderbuilder(TableIddestinationTable,StringsourceUri)
Creates a builder for a BigQuery Load Job configuration given the destination table and source
URI.
| Parameters |
| Name |
Description |
destinationTable |
TableId
|
sourceUri |
String
|
newBuilder(TableId destinationTable, String sourceUri)
publicstaticLoadJobConfiguration.BuildernewBuilder(TableIddestinationTable,StringsourceUri)
Creates a builder for a BigQuery Load Job configuration given the destination table and source
URI.
| Parameters |
| Name |
Description |
destinationTable |
TableId
|
sourceUri |
String
|
publicstaticLoadJobConfiguration.BuildernewBuilder(TableIddestinationTable,StringsourceUri,FormatOptionsformat)
Creates a builder for a BigQuery Load Job configuration given the destination table, format and
source URI.
newBuilder(TableId destinationTable, List<String> sourceUris)
publicstaticLoadJobConfiguration.BuildernewBuilder(TableIddestinationTable,List<String>sourceUris)
Creates a builder for a BigQuery Load Job configuration given the destination table and source
URIs.
publicstaticLoadJobConfiguration.BuildernewBuilder(TableIddestinationTable,List<String>sourceUris,FormatOptionsformat)
Creates a builder for a BigQuery Load Job configuration given the destination table, format and
source URIs.
of(TableId destinationTable, String sourceUri)
publicstaticLoadJobConfigurationof(TableIddestinationTable,StringsourceUri)
Returns a BigQuery Load Job Configuration for the given destination table and source URI.
| Parameters |
| Name |
Description |
destinationTable |
TableId
|
sourceUri |
String
|
publicstaticLoadJobConfigurationof(TableIddestinationTable,StringsourceUri,FormatOptionsformat)
Returns a BigQuery Load Job Configuration for the given destination table, format and source
URI.
of(TableId destinationTable, List<String> sourceUris)
publicstaticLoadJobConfigurationof(TableIddestinationTable,List<String>sourceUris)
Returns a BigQuery Load Job Configuration for the given destination table and source URIs.
publicstaticLoadJobConfigurationof(TableIddestinationTable,List<String>sourceUris,FormatOptionsformat)
Returns a BigQuery Load Job Configuration for the given destination table, format and source
URI.
Methods
equals(Object obj)
publicbooleanequals(Objectobj)
| Parameter |
| Name |
Description |
obj |
Object
|
Overrides
getAutodetect()
publicBooleangetAutodetect()
Returns whether automatic inference of the options and schema for CSV and JSON sources is set.
getClustering()
publicClusteringgetClustering()
Returns the clustering specification for the definition table.
getColumnNameCharacterMap()
publicStringgetColumnNameCharacterMap()
| Returns |
| Type |
Description |
String |
getConnectionProperties()
publicList<ConnectionProperty>getConnectionProperties()
getCreateDisposition()
publicJobInfo.CreateDispositiongetCreateDisposition()
Returns whether the job is allowed to create new tables.
getCreateSession()
publicBooleangetCreateSession()
getCsvOptions()
publicCsvOptionsgetCsvOptions()
Returns additional properties used to parse CSV data (used when #getFormat() is set to
CSV). Returns null if not set.
getDatastoreBackupOptions()
publicDatastoreBackupOptionsgetDatastoreBackupOptions()
Returns additional options used to load from a Cloud datastore backup.
publicStringgetDateFormat()
Returns the format used to parse DATE values.
| Returns |
| Type |
Description |
String |
publicStringgetDatetimeFormat()
Returns the format used to parse DATETIME values.
| Returns |
| Type |
Description |
String |
getDecimalTargetTypes()
publicList<String>getDecimalTargetTypes()
Returns the list of possible SQL data types to which the source decimal values are converted.
This list and the precision and the scale parameters of the decimal field determine the target
type. In the order of NUMERIC, BIGNUMERIC, and STRING, a type is picked if it is in the
specified list and if it supports the precision and the scale. STRING supports all precision
and scale values.
getDestinationEncryptionConfiguration()
publicEncryptionConfigurationgetDestinationEncryptionConfiguration()
getDestinationTable()
publicTableIdgetDestinationTable()
Returns the destination table to load the data into.
getFileSetSpecType()
publicStringgetFileSetSpecType()
| Returns |
| Type |
Description |
String |
Returns the format of the data files.
| Returns |
| Type |
Description |
String |
getHivePartitioningOptions()
publicHivePartitioningOptionsgetHivePartitioningOptions()
getJobTimeoutMs()
publicLonggetJobTimeoutMs()
Returns the timeout associated with this job
| Returns |
| Type |
Description |
Long |
getLabels()
publicMap<String,String>getLabels()
Returns the labels associated with this job
getMaxBadRecords()
publicIntegergetMaxBadRecords()
Returns 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.
getNullMarker()
publicStringgetNullMarker()
Returns the string that represents a null value in a CSV file.
| Returns |
| Type |
Description |
String |
getNullMarkers()
publicList<String>getNullMarkers()
Returns a list of strings represented as SQL NULL value in a CSV file.
getParquetOptions()
publicParquetOptionsgetParquetOptions()
getRangePartitioning()
publicRangePartitioninggetRangePartitioning()
Returns the range partitioning specification for the table
getReferenceFileSchemaUri()
publicStringgetReferenceFileSchemaUri()
| Returns |
| Type |
Description |
String |
getReservation()
publicStringgetReservation()
Returns the reservation associated with this job
| Returns |
| Type |
Description |
String |
getSchema()
Returns the schema for the destination table, if set. Returns null otherwise.
| Returns |
| Type |
Description |
Schema |
getSchemaUpdateOptions()
publicList<JobInfo.SchemaUpdateOption>getSchemaUpdateOptions()
Returns 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.
getSourceColumnMatch()
publicLoadJobConfiguration.SourceColumnMatchgetSourceColumnMatch()
Returns the strategy used to match loaded columns to the schema, either POSITION or NAME.
getSourceUris()
publicList<String>getSourceUris()
Returns the fully-qualified URIs that point to source data in Google Cloud Storage (e.g.
gs://bucket/path). Each URI can contain one '*' wildcard character and it must come after the
'bucket' name.
publicStringgetTimeFormat()
Returns the format used to parse TIME values.
| Returns |
| Type |
Description |
String |
getTimePartitioning()
publicTimePartitioninggetTimePartitioning()
Returns the time partitioning specification defined for the destination table.
getTimeZone()
publicStringgetTimeZone()
Returns the time zone used when parsing timestamp values that don't have specific time zone
information.
| Returns |
| Type |
Description |
String |
publicStringgetTimestampFormat()
Returns the format used to parse TIMESTAMP values.
| Returns |
| Type |
Description |
String |
getUseAvroLogicalTypes()
publicBooleangetUseAvroLogicalTypes()
Returns True/False. Indicates whether the logical type is interpreted.
getWriteDisposition()
publicJobInfo.WriteDispositiongetWriteDisposition()
Returns the action that should occur if the destination table already exists.
hashCode()
| Returns |
| Type |
Description |
int |
Overrides
ignoreUnknownValues()
publicBooleanignoreUnknownValues()
Returns whether BigQuery should allow extra values that are not represented in the table
schema. If true, the extra values are ignored. If true, 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.
toBuilder()
publicLoadJobConfiguration.BuildertoBuilder()
Returns a builder for the object.