Evaluating the DNN models
To evaluate our BigQuery ML DNNs, we'll use the ML.EVALUATE
function and the table that we've expressly created as an evaluation dataset:
- First of all, we can start evaluating the model
`11_nyc_bike_sharing_dnn.trip_duration_by_stations_day_age_relu`
. Let's run the following query:SELECT   * FROM   ML.EVALUATE(MODEL `11_nyc_bike_sharing_dnn.trip_duration_by_stations_day_age_relu`,     (     SELECT           start_station_name,           end_station_name,           is_weekend,           age,           tripduration as label     FROM           `11_nyc_bike_sharing_dnn...