Create ML Models with BigQuery ML: Challenge Lab Reviews

Ashutosh k. · Reviewed over 5 years ago

Siddhi W. · Reviewed over 5 years ago

Atharva M. · Reviewed over 5 years ago

Awesome

Aakash kumar M. · Reviewed over 5 years ago

edgttrj t. · Reviewed over 5 years ago

Aman S. · Reviewed over 5 years ago

Omkar P. · Reviewed over 5 years ago

Prajwal P. · Reviewed over 5 years ago

Rupali S. · Reviewed over 5 years ago

Sreebrata D. · Reviewed over 5 years ago

Sneha P. · Reviewed over 5 years ago

Divyesh K. · Reviewed over 5 years ago

Joshua J. · Reviewed over 5 years ago

Sanjay A. · Reviewed over 5 years ago

Srisha Reddy T. · Reviewed over 5 years ago

Suman P. · Reviewed over 5 years ago

Rahul K. · Reviewed over 5 years ago

Ashutosh S. · Reviewed over 5 years ago

good

Priyadarshan g. · Reviewed over 5 years ago

ANKIT B. · Reviewed over 5 years ago

Vinita S. · Reviewed over 5 years ago

Souvik R. · Reviewed over 5 years ago

Sahil K. · Reviewed over 5 years ago

Anjali K. · Reviewed over 5 years ago

export PROJECT_ID=DEVSHELL_PROJECT_ID bq query --use_legacy_sql=false "CREATE OR REPLACE MODEL austin.austin_1 OPTIONS(input_label_cols=['duration_minutes'], model_type='linear_reg') AS SELECT duration_minutes, location, start_station_name, CAST(EXTRACT(dayofweek FROM start_time) AS STRING) as dayofweek, CAST(EXTRACT(hour FROM start_time) AS STRING) AS hourofday, FROM \`bigquery-public-data.austin_bikeshare.bikeshare_trips\` AS trips JOIN \`bigquery-public-data.austin_bikeshare.bikeshare_stations\` AS stations ON trips.start_station_id = stations.station_id WHERE EXTRACT(year from start_time) = 2018"

Pratik J. · Reviewed over 5 years ago