Learning Google BigQuery

Inserting data to a table

BigQuery allows the insertion of individual rows into a table. For this example, we will start by creating a blank campaign impression table and then use a query to insert individual rows into a table:

1. Find the testdataset dataset. If you do not have this dataset, see step 1 and step 2 in the Creating a Table section.
2. Click on the plus sign next to the testdataset in the left-hand-side navigation. You will be prompted to select your table options. Under Source Data, select Create empty table.
3. Give your table a name: testtable.
4. Under Schema, name the first column date, a type of DATE, and leave the Mode as NULLABLE.
5. Click on Add Field, give the second column a name of campaign, leave the type as STRING, and leave ...