BigQuery Hack: Create Multiple Tables in One Query

Learn how to create multiple tables (concatenated) in one query

Tim Lou, PhD
The Startup
Published in
3 min readJun 17, 2020

--

Learn how to create concatenated tables in BigQuery
Learn how to create concatenated tables in BigQuery

BigQuery (BQ) has become a popular way of managing large databases and running ad-hoc queries. BQ can be very cost-efficient, as it charges by the amount of data queried ($5/TB), and not the amount of computation time. Thus, it can be far cheaper to run computations in BQ…

--

--

Tim Lou, PhD
The Startup

Data Scientist @ TTD | ex Physics Researcher @ Berkeley/LBNL | PhD @ Princeton | Podcast host @ quirkcast.org