Google Apps Script
Feedback on this document

Class JobConfigurationQuery

From BigQuery Services

Members:

MemberTypeDescription
getCreateDispositionString[Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.
getDefaultDatasetDatasetReference[Optional] Specifies the default dataset to assume for unqualified table names in the query.
getDestinationTableTableReference[Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results.
getPriorityString[Experimental] Specifies a priority for the query. Default is INTERACTIVE. Alternative is BATCH, which may be subject to looser quota restrictions.
getQueryString[Required] BigQuery SQL query to execute.
getWriteDispositionString[Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_EMPTY.
setCreateDispositionJobConfigurationQuerySet the value for the field: createDisposition
setDefaultDatasetJobConfigurationQuerySet the value for the field: defaultDataset
setDestinationTableJobConfigurationQuerySet the value for the field: destinationTable
setPriorityJobConfigurationQuerySet the value for the field: priority
setQueryJobConfigurationQuerySet the value for the field: query
setWriteDispositionJobConfigurationQuerySet the value for the field: writeDisposition

method getCreateDisposition()

[Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.

Return Values:

TypeDescription
StringThe current value for createDisposition

method getDefaultDataset()

[Optional] Specifies the default dataset to assume for unqualified table names in the query.

Return Values:

TypeDescription
DatasetReferenceThe current value for defaultDataset

method getDestinationTable()

[Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results.

Return Values:

TypeDescription
TableReferenceThe current value for destinationTable

method getPriority()

[Experimental] Specifies a priority for the query. Default is INTERACTIVE. Alternative is BATCH, which may be subject to looser quota restrictions.

Return Values:

TypeDescription
StringThe current value for priority

method getQuery()

[Required] BigQuery SQL query to execute.

Return Values:

TypeDescription
StringThe current value for query

method getWriteDisposition()

[Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_EMPTY.

Return Values:

TypeDescription
StringThe current value for writeDisposition

method setCreateDisposition(createDisposition)

Set the value for the field: createDisposition

Arguments:

NameTypeDescription
createDispositionString[Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.

Return Values:

TypeDescription
JobConfigurationQueryThe bean object for chaining.

method setDefaultDataset(defaultDataset)

Set the value for the field: defaultDataset

Arguments:

NameTypeDescription
defaultDatasetDatasetReference[Optional] Specifies the default dataset to assume for unqualified table names in the query.

Return Values:

TypeDescription
JobConfigurationQueryThe bean object for chaining.

method setDestinationTable(destinationTable)

Set the value for the field: destinationTable

Arguments:

NameTypeDescription
destinationTableTableReference[Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results.

Return Values:

TypeDescription
JobConfigurationQueryThe bean object for chaining.

method setPriority(priority)

Set the value for the field: priority

Arguments:

NameTypeDescription
priorityString[Experimental] Specifies a priority for the query. Default is INTERACTIVE. Alternative is BATCH, which may be subject to looser quota restrictions.

Return Values:

TypeDescription
JobConfigurationQueryThe bean object for chaining.

method setQuery(query)

Set the value for the field: query

Arguments:

NameTypeDescription
queryString[Required] BigQuery SQL query to execute.

Return Values:

TypeDescription
JobConfigurationQueryThe bean object for chaining.

method setWriteDisposition(writeDisposition)

Set the value for the field: writeDisposition

Arguments:

NameTypeDescription
writeDispositionString[Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_EMPTY.

Return Values:

TypeDescription
JobConfigurationQueryThe bean object for chaining.

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.