Diagram
A process flow showing a SQL query being parsed into an execution tree of stages, exchanged through the distributed shuffle tier, written to persistent storage, and returned, with monitoring via the query plan.
How BigQuery Runs a Query
BigQuery query execution is the distributed process that turns SQL text into parallel work and then stored results. BigQuery first builds an execution tree that breaks the query into stages containing steps that can run in parallel. Stages then exchange intermediate data through a fast distributed shuffle tier that uses a petabit network and RAM to move data to worker nodes, while additional monitoring workers direct progress and can adjust the plan as stage results arrive. When the query finishes, BigQuery writes results to persistent storage and returns them, which lets the next identical run be served from cached results.
Domain 6 of 7
24 practice questions
Practice this DomainLast updated