The Startup
Published in

The Startup

BigQuery Hack: Create Multiple Tables in One Query

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

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…



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Tim Lou, PhD

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