How to add new dataset and upload table in to big query SQL

 If you are using google big query, you can either select dataset from google big query public data or upload your own dataset file.

From the top left hand corner, if you click on Add Data and select public dataset

You have access to a vast number of public datasets available for practicing SQL skills

Once you select public dataset option, it will take you to the next page where you can search from so many datasets(231 at the moment) and start querying them

To upload a dataset from external source, click on three vertical dots in front of your project and select create dataset.

On the page that opens up, project Id should automatically fill, enter name that you want t give to your dataset under data set id and click on create dataset

Now you can see your new dataset customer_data 

Next task is to upload dataset file from your computer to this dataset by clicking on three vertical dots besides customer_data and select create table option

Then on the next page, you can see the option to upload your table from your computer and give it a name (we have given it a name customer_address)

If it is asking you to create schema, select auto select

And now we can see our table uploaded in the dataset customer_data

You can preview it and click on create new query to start querying your data.

A general query to take a look at first 10 rows and columns of this table is given below