We will now use our model, GLM_model_training, to score the testing dataset, testing_table, using the TD_GLMPredict In-Database Analytic Function.
-- Score the GLM model on the testing dataset
CREATE TABLE td_analytics_functions_demo.GLM_model_test_prediction AS (
SELECT * FROM TD_GLMPredict(
ON td_analytics_functions_demo.testing_table AS InputTable
ON td_analytics_functions_demo.GLM_model_training AS ModelTable DIMENSION
USING
IDColumn('cust_id')
Accumulate('cc_avg_bal')
) AS dt
) WITH DATA;