Google launched Short Query Optimized Mode for BigQuery

Lower Latency for Small Queries

Photo by Wenhao Ji on Unsplash

With the new short query optimized mode for you can gain lower latency for small queries. BigQuery automatically determines which queries may be accelerated while other queries continue to run like before[1].

Short query optimized mode is designed to reduce the latency of short queries, which are common in tasks like dashboards or data exploration. This mode processes the query and returns the results directly for SELECTstatements, without creating a job unless BigQuery determines it’s necessary[1][2].

Google launched JSON Keys and Paths for BigQuery

To enable short query optimized mode, set the jobCreationMode field of the QueryRequest instance to JOB_CREATION_OPTIONAL in the jobs.query request body. When the value of this field is set to JOB_CREATION_OPTIONAL, BigQuery determines if the query can use the new short query optimized mode. If so, BigQuery executes the query and returns all results in the rows field of the response. Since a job isn't created for this query, BigQuery doesn't return a jobReference in the response body…