Bigquery, Execution Plan, Query Optimization.
Workers write output to & read input from a common shared temporary storage (shuffle persistence layer) — compute & temporary storage are decoupled Apache Spark chooses the first approach. BigQuery opts for the second. I will not go into details about the differences between shuffling in GCP and