Create ML Models with BigQuery ML: Challenge Lab
LAB CODE:- GSP341 LAB NAME:- Create ML Models with BigQuery ML: Challenge Lab Task 1: Create a dataset to store your machine learning models Open Cloud Shell Terminal and run the following command:- ############################################################################# bq mk austin ############################################################################# Task 2: Create a forecasting BigQuery machine learning model Open BigQuery Console Query Editor and run the following command:- ############################################################################# CREATE OR REPLACE MODEL austin.location_model OPTIONS (model_type='linear_reg', labels=['duration_minutes']) AS SELECT start_station_name AS location, EXTRACT(HOUR FROM start_time) AS start_hour, EXTRACT(DAYOFWEEK FROM start_time) AS day_of_week, duration_minutes, FROM `bigquery-public-data.austin_bikeshare.bikeshare_t...

Comments
Post a Comment
If you have any doubt, let me know?