Using the multiclass logistic regression model
In this section, we'll test our ML model and analyze the results.
To use our BigQuery ML model, we'll use the ML.PREDICT
function and the classification_table
table, which hosts the records, to test our model, as seen in the following code block:
SELECT tree_id, actual_label, predicted_label_probs, predicted_label FROM ML.PREDICT (MODEL `06_nyc_trees.classification_model_version_3`, ( SELECT tree_id, zip_city, tree_dbh, boroname, nta_name, health, sidewalk, spc_latin as actual_label ...