class Google::Apis::BigqueryV2::JobConfigurationQuery
Attributes
If true, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. Corresponds to the JSON property `allowLargeResults` @return [Boolean]
If true, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. Corresponds to the JSON property `allowLargeResults` @return [Boolean]
- 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. Corresponds to the JSON property `createDisposition` @return [String]
- Optional
-
Specifies the default dataset to use for unqualified table names in
the query. Corresponds to the JSON property `defaultDataset` @return [Google::Apis::BigqueryV2::DatasetReference]
- Optional
-
Describes the table where the query results should be stored. If
not present, a new table will be created to store the results. Corresponds to the JSON property `destinationTable` @return [Google::Apis::BigqueryV2::TableReference]
- Optional
-
Flattens all nested and repeated fields in the query results. The
default value is true. allowLargeResults must be true if this is set to false. Corresponds to the JSON property `flattenResults` @return [Boolean]
- Optional
-
Flattens all nested and repeated fields in the query results. The
default value is true. allowLargeResults must be true if this is set to false. Corresponds to the JSON property `flattenResults` @return [Boolean]
- 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. Corresponds to the JSON property `maximumBillingTier` @return [Fixnum]
- Deprecated
-
This property is deprecated.
Corresponds to the JSON property `preserveNulls` @return [Boolean]
- Deprecated
-
This property is deprecated.
Corresponds to the JSON property `preserveNulls` @return [Boolean]
- Optional
-
Specifies a priority for the query. Possible values include
INTERACTIVE and BATCH. The default value is INTERACTIVE. Corresponds to the JSON property `priority` @return [String]
- Required
-
BigQuery SQL query to execute.
Corresponds to the JSON property `query` @return [String]
- 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. Corresponds to the JSON property `tableDefinitions` @return [Hash<String,Google::Apis::BigqueryV2::ExternalDataConfiguration>]
- Experimental
-
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 updated SQL dialect with improved standards compliance. When using BigQuery' s updated SQL, the values of allowLargeResults and flattenResults are ignored. Queries with useLegacySql set to false will be run as if allowLargeResults is true and flattenResults is false. Corresponds to the JSON property `useLegacySql` @return [Boolean]
- Experimental
-
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 updated SQL dialect with improved standards compliance. When using BigQuery' s updated SQL, the values of allowLargeResults and flattenResults are ignored. Queries with useLegacySql set to false will be run as if allowLargeResults is true and flattenResults is false. Corresponds to the JSON property `useLegacySql` @return [Boolean]
- 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. Corresponds to the JSON property `useQueryCache` @return [Boolean]
- 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. Corresponds to the JSON property `useQueryCache` @return [Boolean]
- Experimental
-
Describes user-defined function resources used in the query.
Corresponds to the JSON property `userDefinedFunctionResources` @return [Array<Google::Apis::BigqueryV2::UserDefinedFunctionResource>]
- 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. 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. Corresponds to the JSON property `writeDisposition` @return [String]
Public Class Methods
# File generated/google/apis/bigquery_v2/classes.rb, line 1392 def initialize(**args) update!(**args) end
Public Instance Methods
Update properties of this object
# File generated/google/apis/bigquery_v2/classes.rb, line 1397 def update!(**args) @allow_large_results = args[:allow_large_results] if args.key?(:allow_large_results) @create_disposition = args[:create_disposition] if args.key?(:create_disposition) @default_dataset = args[:default_dataset] if args.key?(:default_dataset) @destination_table = args[:destination_table] if args.key?(:destination_table) @flatten_results = args[:flatten_results] if args.key?(:flatten_results) @maximum_billing_tier = args[:maximum_billing_tier] if args.key?(:maximum_billing_tier) @preserve_nulls = args[:preserve_nulls] if args.key?(:preserve_nulls) @priority = args[:priority] if args.key?(:priority) @query = args[:query] if args.key?(:query) @table_definitions = args[:table_definitions] if args.key?(:table_definitions) @use_legacy_sql = args[:use_legacy_sql] if args.key?(:use_legacy_sql) @use_query_cache = args[:use_query_cache] if args.key?(:use_query_cache) @user_defined_function_resources = args[:user_defined_function_resources] if args.key?(:user_defined_function_resources) @write_disposition = args[:write_disposition] if args.key?(:write_disposition) end