public abstract static class ExternalTableDefinition.Builder extends TableDefinition.Builder<ExternalTableDefinition,ExternalTableDefinition.Builder>
Constructors
Builder()
Methods
build()
public abstract ExternalTableDefinition build()
Creates an ExternalTableDefinition
object.
Returns
Overrides
setAutodetect(Boolean autodetect)
public abstract ExternalTableDefinition.Builder setAutodetect(Boolean autodetect)
[Experimental] Sets detection of schema and format options automatically. Any option
specified explicitly will be honored.
Parameter
Returns
setCompression(String compression)
public abstract ExternalTableDefinition.Builder setCompression(String compression)
Sets compression type of the data source. By default no compression is assumed.
See Also: Compression
Parameter
Name | Description |
compression | String
|
Returns
setConnectionId(String connectionId)
public abstract ExternalTableDefinition.Builder setConnectionId(String connectionId)
[Optional, Trusted Tester] connectionId for external data source. The value may be
null
.
Parameter
Name | Description |
connectionId | String
|
Returns
setDecimalTargetTypes(List<String> decimalTargetTypes)
public abstract ExternalTableDefinition.Builder setDecimalTargetTypes(List<String> decimalTargetTypes)
Defines 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.
Parameter
Name | Description |
decimalTargetTypes | List<String>
decimalTargetType or null for none
|
Returns
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
Parameter
Returns
setHivePartitioningOptions(HivePartitioningOptions hivePartitioningOptions)
public ExternalTableDefinition.Builder setHivePartitioningOptions(HivePartitioningOptions hivePartitioningOptions)
Sets the table Hive partitioning options.
Parameter
Returns
setIgnoreUnknownValues(Boolean ignoreUnknownValues)
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
Parameter
Name | Description |
ignoreUnknownValues | Boolean
|
Returns
setMaxBadRecords(Integer maxBadRecords)
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.
Parameter
Name | Description |
maxBadRecords | Integer
|
Returns
setSchema(Schema schema)
public abstract ExternalTableDefinition.Builder setSchema(Schema schema)
Parameter
Returns
Overrides
setSourceUris(List<String> sourceUris)
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
Parameter
Returns
setType(TableDefinition.Type type)
public abstract ExternalTableDefinition.Builder setType(TableDefinition.Type type)
Parameter
Returns
Overrides