Learning Google BigQuery

Creating a partition table using a GUI

Download the sample file from this URL and upload it to a Google Cloud Storage bucket: https://github.com/hthirukkumaran/Learning-Google-BigQuery/blob/master/chapter1/employeedetails.csv. And note down the bucket name.

1. Click on the Create new table option under the Dataset menu.
2. To create a partition table, enable the partition option by choosing Day in the Partitioning drop-down as shown in the following screenshot. Enter the file from Google Cloud Storage to import data into the new table.

3. Click on the Create Table button to create the table and import the data from the file:

Once the table is created, ...