bigquery
v2
|
#include <job_configuration_query.h>
Static Public Member Functions | |
static JobConfigurationQuery * | New () |
No description provided.
|
explicit |
Standard constructor for an immutable data object instance.
[in] | storage | The underlying data storage for this instance. |
|
explicit |
Standard constructor for a mutable data object instance.
[in] | storage | The underlying data storage for this instance. |
|
virtual |
Standard destructor.
|
inline |
Clears the 'allowLargeResults
' attribute.
|
inline |
Clears the 'clustering
' attribute.
|
inline |
Clears the 'createDisposition
' attribute.
|
inline |
Clears the 'defaultDataset
' attribute.
|
inline |
Clears the 'destinationEncryptionConfiguration
' attribute.
|
inline |
Clears the 'destinationTable
' attribute.
|
inline |
Clears the 'flattenResults
' attribute.
|
inline |
Clears the 'maximumBillingTier
' attribute.
|
inline |
Clears the 'maximumBytesBilled
' attribute.
|
inline |
Clears the 'parameterMode
' attribute.
|
inline |
Clears the 'preserveNulls
' attribute.
|
inline |
Clears the 'priority
' attribute.
|
inline |
Clears the 'query
' attribute.
|
inline |
Clears the 'queryParameters
' attribute.
|
inline |
Clears the 'rangePartitioning
' attribute.
|
inline |
Clears the 'schemaUpdateOptions
' attribute.
|
inline |
Clears the 'tableDefinitions
' attribute.
|
inline |
Clears the 'timePartitioning
' attribute.
|
inline |
Clears the 'useLegacySql
' attribute.
|
inline |
Clears the 'useQueryCache
' attribute.
|
inline |
Clears the 'userDefinedFunctionResources
' attribute.
|
inline |
Clears the 'writeDisposition
' attribute.
|
inline |
Get the value of the 'allowLargeResults
' attribute.
const Clustering google_bigquery_api::JobConfigurationQuery::get_clustering | ( | ) | const |
Get a reference to the value of the 'clustering
' attribute.
|
inline |
Get the value of the 'createDisposition
' attribute.
const DatasetReference google_bigquery_api::JobConfigurationQuery::get_default_dataset | ( | ) | const |
Get a reference to the value of the 'defaultDataset
' attribute.
const EncryptionConfiguration google_bigquery_api::JobConfigurationQuery::get_destination_encryption_configuration | ( | ) | const |
Get a reference to the value of the 'destinationEncryptionConfiguration
' attribute.
const TableReference google_bigquery_api::JobConfigurationQuery::get_destination_table | ( | ) | const |
Get a reference to the value of the 'destinationTable
' attribute.
|
inline |
Get the value of the 'flattenResults
' attribute.
|
inline |
Get the value of the 'maximumBillingTier
' attribute.
|
inline |
Get the value of the 'maximumBytesBilled
' attribute.
|
inline |
Get the value of the 'parameterMode
' attribute.
|
inline |
Get the value of the 'preserveNulls
' attribute.
|
inline |
Get the value of the 'priority
' attribute.
|
inline |
Get the value of the 'query
' attribute.
const client::JsonCppArray<QueryParameter > google_bigquery_api::JobConfigurationQuery::get_query_parameters | ( | ) | const |
Get a reference to the value of the 'queryParameters
' attribute.
const RangePartitioning google_bigquery_api::JobConfigurationQuery::get_range_partitioning | ( | ) | const |
Get a reference to the value of the 'rangePartitioning
' attribute.
|
inline |
Get a reference to the value of the 'schemaUpdateOptions
' attribute.
const client::JsonCppAssociativeArray<ExternalDataConfiguration > google_bigquery_api::JobConfigurationQuery::get_table_definitions | ( | ) | const |
Get a reference to the value of the 'tableDefinitions
' attribute.
const TimePartitioning google_bigquery_api::JobConfigurationQuery::get_time_partitioning | ( | ) | const |
Get a reference to the value of the 'timePartitioning
' attribute.
|
inline |
Get the value of the 'useLegacySql
' attribute.
|
inline |
Get the value of the 'useQueryCache
' attribute.
const client::JsonCppArray<UserDefinedFunctionResource > google_bigquery_api::JobConfigurationQuery::get_user_defined_function_resources | ( | ) | const |
Get a reference to the value of the 'userDefinedFunctionResources
' attribute.
|
inline |
Get the value of the 'writeDisposition
' attribute.
|
inline |
Returns a string denoting the type of this data object.
|
inline |
Determine if the 'allowLargeResults
' attribute was set.
allowLargeResults
' attribute was set.
|
inline |
Determine if the 'clustering
' attribute was set.
clustering
' attribute was set.
|
inline |
Determine if the 'createDisposition
' attribute was set.
createDisposition
' attribute was set.
|
inline |
Determine if the 'defaultDataset
' attribute was set.
defaultDataset
' attribute was set.
|
inline |
Determine if the 'destinationEncryptionConfiguration
' attribute was set.
destinationEncryptionConfiguration
' attribute was set.
|
inline |
Determine if the 'destinationTable
' attribute was set.
destinationTable
' attribute was set.
|
inline |
Determine if the 'flattenResults
' attribute was set.
flattenResults
' attribute was set.
|
inline |
Determine if the 'maximumBillingTier
' attribute was set.
maximumBillingTier
' attribute was set.
|
inline |
Determine if the 'maximumBytesBilled
' attribute was set.
maximumBytesBilled
' attribute was set.
|
inline |
Determine if the 'parameterMode
' attribute was set.
parameterMode
' attribute was set.
|
inline |
Determine if the 'preserveNulls
' attribute was set.
preserveNulls
' attribute was set.
|
inline |
Determine if the 'priority
' attribute was set.
priority
' attribute was set.
|
inline |
Determine if the 'query
' attribute was set.
query
' attribute was set.
|
inline |
Determine if the 'queryParameters
' attribute was set.
queryParameters
' attribute was set.
|
inline |
Determine if the 'rangePartitioning
' attribute was set.
rangePartitioning
' attribute was set.
|
inline |
Determine if the 'schemaUpdateOptions
' attribute was set.
schemaUpdateOptions
' attribute was set.
|
inline |
Determine if the 'tableDefinitions
' attribute was set.
tableDefinitions
' attribute was set.
|
inline |
Determine if the 'timePartitioning
' attribute was set.
timePartitioning
' attribute was set.
|
inline |
Determine if the 'useLegacySql
' attribute was set.
useLegacySql
' attribute was set.
|
inline |
Determine if the 'useQueryCache
' attribute was set.
useQueryCache
' attribute was set.
|
inline |
Determine if the 'userDefinedFunctionResources
' attribute was set.
userDefinedFunctionResources
' attribute was set.
|
inline |
Determine if the 'writeDisposition
' attribute was set.
writeDisposition
' attribute was set. Clustering google_bigquery_api::JobConfigurationQuery::mutable_clustering | ( | ) |
Gets a reference to a mutable value of the 'clustering
' property.
[Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
DatasetReference google_bigquery_api::JobConfigurationQuery::mutable_defaultDataset | ( | ) |
Gets a reference to a mutable value of the 'defaultDataset
' property.
[Optional] Specifies the default dataset to use for unqualified table names in the query. Note that this does not alter behavior of unqualified dataset names.
EncryptionConfiguration google_bigquery_api::JobConfigurationQuery::mutable_destinationEncryptionConfiguration | ( | ) |
Gets a reference to a mutable value of the 'destinationEncryptionConfiguration
' property.
Custom encryption configuration (e.g., Cloud KMS keys).
TableReference google_bigquery_api::JobConfigurationQuery::mutable_destinationTable | ( | ) |
Gets a reference to a mutable value of the 'destinationTable
' property.
[Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results. This property must be set for large results that exceed the maximum response size.
client::JsonCppArray<QueryParameter > google_bigquery_api::JobConfigurationQuery::mutable_queryParameters | ( | ) |
Gets a reference to a mutable value of the 'queryParameters
' property.
Query parameters for standard SQL queries.
RangePartitioning google_bigquery_api::JobConfigurationQuery::mutable_rangePartitioning | ( | ) |
Gets a reference to a mutable value of the 'rangePartitioning
' property.
[TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
|
inline |
Gets a reference to a mutable value of the 'schemaUpdateOptions
' property.
Allows 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. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
client::JsonCppAssociativeArray<ExternalDataConfiguration > google_bigquery_api::JobConfigurationQuery::mutable_tableDefinitions | ( | ) |
Gets a reference to a mutable value of the 'tableDefinitions
' property.
[Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.
TimePartitioning google_bigquery_api::JobConfigurationQuery::mutable_timePartitioning | ( | ) |
Gets a reference to a mutable value of the 'timePartitioning
' property.
Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
client::JsonCppArray<UserDefinedFunctionResource > google_bigquery_api::JobConfigurationQuery::mutable_userDefinedFunctionResources | ( | ) |
Gets a reference to a mutable value of the 'userDefinedFunctionResources
' property.
Describes user-defined function resources used in the query.
|
static |
Creates a new default instance.
|
inline |
Change the 'allowLargeResults
' attribute.
[Optional] If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed. However, you must still set destinationTable when result size exceeds the allowed maximum response size.
[in] | value | The new value. |
|
inline |
Change the 'createDisposition
' attribute.
[Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
[in] | value | The new value. |
|
inline |
Change the 'flattenResults
' attribute.
[Optional] If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results. allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
[in] | value | The new value. |
|
inline |
Change the 'maximumBillingTier
' attribute.
[Optional] 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.
[in] | value | The new value. |
|
inline |
Change the 'maximumBytesBilled
' attribute.
[Optional] Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default.
[in] | value | The new value. |
|
inline |
Change the 'parameterMode
' attribute.
Standard SQL only. Set to POSITIONAL to use positional (?) query parameters or to NAMED to use named () query parameters in this query.
[in] | value | The new value. |
|
inline |
Change the 'preserveNulls
' attribute.
[Deprecated] This property is deprecated.
[in] | value | The new value. |
|
inline |
Change the 'priority
' attribute.
[Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.
[in] | value | The new value. |
|
inline |
Change the 'query
' attribute.
[Required] SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
[in] | value | The new value. |
|
inline |
Change the 'useLegacySql
' attribute.
Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the value of flattenResults is ignored; query will be run as if flattenResults is false.
[in] | value | The new value. |
|
inline |
Change the 'useQueryCache
' attribute.
[Optional] 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 a query does not have a destination table specified. The default value is true.
[in] | value | The new value. |
|
inline |
Change the 'writeDisposition
' attribute.
[Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
[in] | value | The new value. |