QueryJobConfiguration.Builder (Google Cloud BigQuery 0.20.3-beta API)

java.lang.Object
- com.google.cloud.bigquery.JobConfiguration.Builder<QueryJobConfiguration,QueryJobConfiguration.Builder>
- - com.google.cloud.bigquery.QueryJobConfiguration.Builder

Enclosing class:: QueryJobConfiguration

public static final class QueryJobConfiguration.Builder
extends JobConfiguration.Builder<QueryJobConfiguration,QueryJobConfiguration.Builder>

Method Summary

Methods
Modifier and Type	Method and Description
`QueryJobConfiguration.Builder`	`addTableDefinition(String tableName, ExternalTableDefinition tableDefinition)` Adds a new external table definition.
`QueryJobConfiguration`	`build()` Creates an object.
`QueryJobConfiguration.Builder`	`setAllowLargeResults(Boolean allowLargeResults)` Sets whether the job is enabled to create arbitrarily large results.
`QueryJobConfiguration.Builder`	`setCreateDisposition(JobInfo.CreateDisposition createDisposition)` Sets whether the job is allowed to create tables.
`QueryJobConfiguration.Builder`	`setDefaultDataset(DatasetId defaultDataset)` Sets the default dataset.
`QueryJobConfiguration.Builder`	`setDefaultDataset(String defaultDataset)` Sets the default dataset.
`QueryJobConfiguration.Builder`	`setDestinationTable(TableId destinationTable)` Sets the table where to put query results.
`QueryJobConfiguration.Builder`	`setDryRun(Boolean dryRun)` Sets whether the job has to be dry run or not.
`QueryJobConfiguration.Builder`	`setFlattenResults(Boolean flattenResults)` Sets whether nested and repeated fields should be flattened.
`QueryJobConfiguration.Builder`	`setMaximumBillingTier(Integer maximumBillingTier)` Limits the billing tier for this job.
`QueryJobConfiguration.Builder`	`setPriority(QueryJobConfiguration.Priority priority)` Sets a priority for the query.
`QueryJobConfiguration.Builder`	`setQuery(String query)` Sets the BigQuery SQL query to execute.
`QueryJobConfiguration.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 query job.
`QueryJobConfiguration.Builder`	`setTableDefinitions(Map<String,ExternalTableDefinition> tableDefinitions)` Sets the external tables definitions.
`QueryJobConfiguration.Builder`	`setUseLegacySql(Boolean useLegacySql)` Sets whether to use BigQuery's legacy SQL dialect for this query.
`QueryJobConfiguration.Builder`	`setUseQueryCache(Boolean useQueryCache)` Sets whether to look for the result in the query cache.
`QueryJobConfiguration.Builder`	`setUserDefinedFunctions(List<UserDefinedFunction> userDefinedFunctions)` Sets user defined function resources that can be used by this query.
`QueryJobConfiguration.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
  - setQuery
```
public QueryJobConfiguration.Builder setQuery(String query)
```
    Sets the BigQuery SQL query to execute.
  - setDestinationTable
```
public QueryJobConfiguration.Builder setDestinationTable(TableId destinationTable)
```
    Sets the table where to put query results. If not provided a new table is created. This value is required if setAllowLargeResults(Boolean) is set to true.
  - setTableDefinitions
```
public QueryJobConfiguration.Builder setTableDefinitions(Map<String,ExternalTableDefinition> tableDefinitions)
```
    Sets the external tables definitions. If querying external data sources outside of BigQuery, this value describes the data format, location and other properties of the data sources. By defining these properties, the data sources can be queried as if they were standard BigQuery tables.
  - addTableDefinition
```
public QueryJobConfiguration.Builder addTableDefinition(String tableName,
                                               ExternalTableDefinition tableDefinition)
```
    Adds a new external table definition. If a definition already exists for tableName it is updated.
    
    Parameters:
    tableName - name of the table
    tableDefinition - external data configuration for the table used by this query
  - setUserDefinedFunctions
```
public QueryJobConfiguration.Builder setUserDefinedFunctions(List<UserDefinedFunction> userDefinedFunctions)
```
    Sets user defined function resources that can be used by this query. Function resources can either be defined inline (UserDefinedFunction.inline(String)) or loaded from a Google Cloud Storage URI (UserDefinedFunction.fromUri(String).
  - setCreateDisposition
```
public QueryJobConfiguration.Builder setCreateDisposition(JobInfo.CreateDisposition createDisposition)
```
    Sets whether the job is allowed to create tables.
    
    See Also:
    Create Disposition
  - setWriteDisposition
```
public QueryJobConfiguration.Builder setWriteDisposition(JobInfo.WriteDisposition writeDisposition)
```
    Sets the action that should occur if the destination table already exists.
    
    See Also:
    Write Disposition
  - setDefaultDataset
```
public QueryJobConfiguration.Builder setDefaultDataset(DatasetId defaultDataset)
```
    Sets the default dataset. This dataset is used for all unqualified table names used in the query.
  - setDefaultDataset
```
public QueryJobConfiguration.Builder setDefaultDataset(String defaultDataset)
```
    Sets the default dataset. This dataset is used for all unqualified table names used in the query.
  - setPriority
```
public QueryJobConfiguration.Builder setPriority(QueryJobConfiguration.Priority priority)
```
    Sets a priority for the query. If not specified the priority is assumed to be QueryJobConfiguration.Priority.INTERACTIVE.
  - setAllowLargeResults
```
public QueryJobConfiguration.Builder setAllowLargeResults(Boolean allowLargeResults)
```
    Sets whether the job is enabled to create arbitrarily large results. If true the query is allowed to create large results at a slight cost in performance. If true setDestinationTable(TableId) must be provided.
    
    See Also:
    Returning Large Query Results
  - setUseQueryCache
```
public QueryJobConfiguration.Builder setUseQueryCache(Boolean useQueryCache)
```
    Sets whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when setDestinationTable(TableId) is not set.
    
    See Also:
    Query Caching
  - setFlattenResults
```
public QueryJobConfiguration.Builder setFlattenResults(Boolean flattenResults)
```
    Sets whether nested and repeated fields should be flattened. If set to false setAllowLargeResults(Boolean) must be true. By default results are flattened.
    
    See Also:
    Flatten
  - setDryRun
```
public QueryJobConfiguration.Builder setDryRun(Boolean dryRun)
```
    Sets whether the job has to be dry run or not. If set, the job is not executed. A valid query will return a mostly empty response with some processing statistics, while an invalid query will return the same error it would if it wasn't a dry run.
  - setUseLegacySql
```
public QueryJobConfiguration.Builder setUseLegacySql(Boolean useLegacySql)
```
    Sets whether to use BigQuery's legacy SQL dialect for this query. If set to false, the query will use BigQuery's Standard SQL. When set to false, the values of setAllowLargeResults(Boolean) and setFlattenResults(Boolean) are ignored; query will be run as if setAllowLargeResults(Boolean) is true and setFlattenResults(Boolean) is false. If not set, legacy SQL dialect is used. This property is experimental and might be subject to change.
  - setMaximumBillingTier
```
public QueryJobConfiguration.Builder setMaximumBillingTier(Integer maximumBillingTier)
```
    Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.
    
    Parameters:
    maximumBillingTier - maximum billing tier for this job
  - setSchemaUpdateOptions
```
public QueryJobConfiguration.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 query 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.
  - build
```
public QueryJobConfiguration build()
```
    Description copied from class: JobConfiguration.Builder
    
    Creates an object.
    
    Specified by:
    
    build in class JobConfiguration.Builder<QueryJobConfiguration,QueryJobConfiguration.Builder>

Class QueryJobConfiguration.Builder

Method Summary

Methods inherited from class java.lang.Object

Method Detail

setQuery

setDestinationTable

setTableDefinitions

addTableDefinition

setUserDefinedFunctions

setCreateDisposition

setWriteDisposition

setDefaultDataset

setDefaultDataset

setPriority

setAllowLargeResults

setUseQueryCache

setFlattenResults

setDryRun

setUseLegacySql

setMaximumBillingTier

setSchemaUpdateOptions

build