Class: Google::Apis::BigqueryV2::QueryRequest
- Inherits:
-
Object
- Object
- Google::Apis::BigqueryV2::QueryRequest
- Includes:
- Core::Hashable, Core::JsonObjectSupport
- Defined in:
- generated/google/apis/bigquery_v2/classes.rb,
generated/google/apis/bigquery_v2/representations.rb,
generated/google/apis/bigquery_v2/representations.rb
Instance Attribute Summary collapse
-
#default_dataset ⇒ Google::Apis::BigqueryV2::DatasetReference
[Optional] Specifies the default datasetId and projectId to assume for any unqualified table names in the query.
-
#dry_run ⇒ Boolean
(also: #dry_run?)
[Optional] If set to true, BigQuery doesn't run the job.
-
#kind ⇒ String
The resource type of the request.
-
#max_results ⇒ Fixnum
[Optional] The maximum number of rows of data to return per page of results.
-
#parameter_mode ⇒ String
[Experimental] Standard SQL only.
-
#preserve_nulls ⇒ Boolean
(also: #preserve_nulls?)
[Deprecated] This property is deprecated.
-
#query ⇒ String
[Required] A query string, following the BigQuery query syntax, of the query to execute.
-
#query_parameters ⇒ Array<Google::Apis::BigqueryV2::QueryParameter>
[Experimental] Query parameters for Standard SQL queries.
-
#timeout_ms ⇒ Fixnum
[Optional] How long to wait for the query to complete, in milliseconds, before the request times out and returns.
-
#use_legacy_sql ⇒ Boolean
(also: #use_legacy_sql?)
[Experimental] Specifies whether to use BigQuery's legacy SQL dialect for this query.
-
#use_query_cache ⇒ Boolean
(also: #use_query_cache?)
[Optional] Whether to look for the result in the query cache.
Instance Method Summary collapse
-
#initialize(**args) ⇒ QueryRequest
constructor
A new instance of QueryRequest.
-
#update!(**args) ⇒ Object
Update properties of this object.
Methods included from Core::JsonObjectSupport
Methods included from Core::Hashable
Constructor Details
#initialize(**args) ⇒ QueryRequest
Returns a new instance of QueryRequest.
2247 2248 2249 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2247 def initialize(**args) update!(**args) end |
Instance Attribute Details
#default_dataset ⇒ Google::Apis::BigqueryV2::DatasetReference
[Optional] Specifies the default datasetId and projectId to assume for any
unqualified table names in the query. If not set, all table names in the query
string must be qualified in the format 'datasetId.tableId'.
Corresponds to the JSON property defaultDataset
2169 2170 2171 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2169 def default_dataset @default_dataset end |
#dry_run ⇒ Boolean Also known as: dry_run?
[Optional] If set to true, BigQuery doesn't run the job. Instead, if the query
is valid, BigQuery returns statistics about the job such as how many bytes
would be processed. If the query is invalid, an error returns. The default
value is false.
Corresponds to the JSON property dryRun
2177 2178 2179 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2177 def dry_run @dry_run end |
#kind ⇒ String
The resource type of the request.
Corresponds to the JSON property kind
2183 2184 2185 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2183 def kind @kind end |
#max_results ⇒ Fixnum
[Optional] The maximum number of rows of data to return per page of results.
Setting this flag to a small value such as 1000 and then paging through
results might improve reliability when the query result set is large. In
addition to this limit, responses are also limited to 10 MB. By default, there
is no maximum row count, and only the byte limit applies.
Corresponds to the JSON property maxResults
2192 2193 2194 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2192 def max_results @max_results end |
#parameter_mode ⇒ String
[Experimental] Standard SQL only. Whether to use positional (?) or named (@
myparam) query parameters in this query.
Corresponds to the JSON property parameterMode
2198 2199 2200 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2198 def parameter_mode @parameter_mode end |
#preserve_nulls ⇒ Boolean Also known as: preserve_nulls?
[Deprecated] This property is deprecated.
Corresponds to the JSON property preserveNulls
2203 2204 2205 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2203 def preserve_nulls @preserve_nulls end |
#query ⇒ String
[Required] A query string, following the BigQuery query syntax, of the query
to execute. Example: "SELECT count(f1) FROM [myProjectId:myDatasetId.myTableId]
".
Corresponds to the JSON property query
2211 2212 2213 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2211 def query @query end |
#query_parameters ⇒ Array<Google::Apis::BigqueryV2::QueryParameter>
[Experimental] Query parameters for Standard SQL queries.
Corresponds to the JSON property queryParameters
2216 2217 2218 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2216 def query_parameters @query_parameters end |
#timeout_ms ⇒ Fixnum
[Optional] How long to wait for the query to complete, in milliseconds, before
the request times out and returns. Note that this is only a timeout for the
request, not the query. If the query takes longer to run than the timeout
value, the call returns without any results and with the 'jobComplete' flag
set to false. You can call GetQueryResults() to wait for the query to complete
and read the results. The default value is 10000 milliseconds (10 seconds).
Corresponds to the JSON property timeoutMs
2226 2227 2228 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2226 def timeout_ms @timeout_ms end |
#use_legacy_sql ⇒ Boolean Also known as: use_legacy_sql?
[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 standard SQL: https://cloud.google.com/bigquery/sql-reference/ When
useLegacySql is set to false, the values of allowLargeResults and
flattenResults are ignored; query will be run as if allowLargeResults is true
and flattenResults is false.
Corresponds to the JSON property useLegacySql
2236 2237 2238 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2236 def use_legacy_sql @use_legacy_sql end |
#use_query_cache ⇒ Boolean Also known as: use_query_cache?
[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. The default value is true.
Corresponds to the JSON property useQueryCache
2244 2245 2246 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2244 def use_query_cache @use_query_cache end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2252 def update!(**args) @default_dataset = args[:default_dataset] if args.key?(:default_dataset) @dry_run = args[:dry_run] if args.key?(:dry_run) @kind = args[:kind] if args.key?(:kind) @max_results = args[:max_results] if args.key?(:max_results) @parameter_mode = args[:parameter_mode] if args.key?(:parameter_mode) @preserve_nulls = args[:preserve_nulls] if args.key?(:preserve_nulls) @query = args[:query] if args.key?(:query) @query_parameters = args[:query_parameters] if args.key?(:query_parameters) @timeout_ms = args[:timeout_ms] if args.key?(:timeout_ms) @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) end |