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.