March 2019
Beginner to intermediate
778 pages
34h 20m
English
In order to understand the use cases and limitations of BigQuery, it's helpful to know a bit about how BigQuery actually works. When a user executes a query in BigQuery, that query is processed by root servers that interpret the query into a series of operations. It then passes these operations through layers of intermediate servers, which orchestrate the execution of those operations across many leaf servers. Only at the leaf servers is any data actually read from disk. As leaf servers fulfill their requests, the intermediate servers receive their results, piecing them together and applying any higher-level computations before returning results to the root server and eventually the end user:
By spreading query ...
Read now
Unlock full access