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...