BigQuery Hack: How to Quickly Populate a Table Without INSERT()

How to use BigQuery’s UI and a bit of SQL to populate a newly created table.

Reader Note: Before we begin, I have to warn you that the following is not considered to be a best SQL practice and is certainly not a textbook case of data engineering. It’s, at best, a quick trick that will be most effective when you need to create a bit of test data from scratch when time is of the essence. Replicate at your own discretion.



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