Data loading from CSV upload

In the previous two chapters, we loaded data from a local file and from Google Cloud Storage. For this example, we will load data again using local CSV files. If you have not already, download the two datasets in the Technical requirements section to your local workstation so you can load them into BigQuery.

Follow these steps to load our example datasets into BigQuery:

1. Open the BigQuery console: https://console.cloud.google.com/bigquery.
2. Select your project and create a new dataset:

Figure 13.3 – Create a new dataset in an expanded project in the BigQuery console

3. Give the dataset the dataset ID ch13, keep it set to multi-region US, and leave all options as the default. Click Create dataset.
4. Click the three dots on your newly created dataset and click Create table, as shown in the following screenshot.

Figure 13.4 – Create a table in the newly created...