Model evaluation

Finally, we evaluate our model on the scored results. We will use the TD_RegressionEvaluator function for model evaluation. The model can be evaluated using metrics such as RMSE, MAE, and R2.

-- Evaluate the model
SELECT * FROM TD_RegressionEvaluator(
  ON td_analytics_functions_demo.GLM_model_test_prediction AS InputTable
  USING
  ObservationColumn('cc_avg_bal')
  PredictionColumn('prediction')
  Metrics('RMSE', 'MAE', 'R2')
) AS dt;

Evaluated GLM

Note

The purpose of this how-to is not to describe feature engineering in detail, but to demonstrate how we can use different In-Database Analytic Functions in Teradata. The model results might not be optimal, and the process of building the best model is beyond the scope of this article.