How to upload dataset and table to bigquery SQL by adding data type manually

 In the previous post, we went through uploading table to big query SQL by selecting Auto detect option in schema.

In this post, we will see how we can add data types manually while uploading table.

In the previous post

In this post, instead of selecting auto select, we can select edit as text option

So basically, instead of letting the system select schema automatically, we are going to write schema manually

Here is the snapshot of the csv table that we are going to upload

For columns with numerical values(without decimal point), we will select integer data type

For columns with text values, we will select String data type

For columns with date we will select DateTime data type

For columns with numerical values(with decimal point), we will select float data type

Adding dictionary format in the space to edit text

Once you click create table, our table is uploaded

Our desired table is uploaded and we can see first few rows by clicking preview