ML train with taxi data

.https://google.qwiklabs.com/focuses/12379

CREATE OR REPLACE MODEL `qwiklabs-gcp-00-c1b9353b74ea.taxirides.fare_model`
TRANSFORM(ST_Distance(ST_GeogPoint(pickuplon, pickuplat), ST_GeogPoint(dropofflon, dropofflat)) AS euclidean,
   total_amount)
OPTIONS(MODEL_TYPE='LOGISTIC_REG', INPUT_LABEL_COLS=['total_amount'])

AS SELECT total_amount,
#ST_Distance(ST_GeogPoint(pickuplon, pickuplat), ST_GeogPoint(dropofflon, dropofflat)) AS euclidean
FROM `qwiklabs-gcp-00-c1b9353b74ea.taxirides.taxi_training_data`

SELECT *

FROM 
  ML.PREDICT( MODEL `qwiklabs-gcp-00-c1b9353b74ea.taxirides.fare_model`, (SELECT * FROM `qwiklabs-gcp-00-c1b9353b74ea.taxirides.report_prediction_data`) )

BigQueryQueryRead took a long time and failed.