Using the binary logistic regression model

In this section, we'll use the ML model to predict the probability of getting a tip from our customers.

To test our BigQuery ML model, we'll use the ML.PREDICT function on the classification_table table:

SELECT predicted_will_get_tip, predicted_will_get_tip_probs, will_get_tip actual
FROM
  ML.PREDICT(MODEL`05_chicago_taxi.binary_classification_version_5`,
    (
      SELECT
        trip_seconds,
        fare,
        tolls,
        company,
        payment_type,
        pickup_location,
        dropoff_location,
        IF(tips>0,1,0) AS will_get_tip...