Loading data with csv file in Google Bigquery

In Google Cloud BigQuery we can load data from the csv file. We can create a dataset under the Google Project. Within the dataset we create tables.

Wine quality data is available in Kaggle.

Next, we create a table within this dataset.

Here we are creating a table with upload option. We have provided the file path and the file format. The dataset name has been provided. When Auto detect is selected then the schema gets created automatically during the table creation.

The schema tab list the schema details of the table. The details tab provide us with table details like the total number of rows etc. With the preview tab we can inspect the rows of data populated.

Once we have the data loaded we can either run SQL queries in the BigQuery console or we can execute the queries directly in the Jupiter notebook and perform our analysis and visualization.