Tagged with

1 article found

BigQuery CTEs: The Cost-Free Abstraction Nobody Understands

CTEs don’t cost extra in BigQuery. But star notation and global scans do. Here’s exactly what happens under the hood when you chain five WITH clauses on a 30GB table.

#bigquery#CTEs#Data Engineering...