Prerequisites

GCP account

Open Cloud shell.

Paste the Below Code in Console.

bq load \

–source_format=CSV \

–autodetect \

–noreplace \

nyc_taxi.2018_trips \

gs://cloud-training/OCBL013/nyc_tlc_yellow_trips_2018_subset_1.csv

It will add the file into the Bigquery.

Open the Table and check the details.

Paste the below code.

CREATE TABLE

     nyc_taxi.january_trips AS

SELECT

     *

FROM

     nyc_taxi.2018_trips

WHERE

     EXTRACT(Month

     FROM

          pickup_datetime)=1;

Click Run.

 It will create a new table named January_trips.

It will create a new table named January_trips.