Error with predict_binary_classifier(*)

[yiwang]

Followed the steps and failed on

SELECT *, predict_binary_classifier(*) AS PREDICTION 
  FROM (SELECT * EXCLUDE CUSTOMERID from CUSTOMER limit 100);

at https://modelstar.io/docs/tutorials/churn-prediction-inside-snowflake/#step-3-model-inference
with error message

Error: too many arguments for function [PREDICT_BINARY_CLASSIFIER("values".GENDER, "values".SENIORCITIZEN, "values".PARTNER, "values".DEPENDENTS, "values".TENURE, "values".PHONESERVICE, "values".MULTIPLELINES, "values".INTERNETSERVICE, "values".ONLINESECURITY, "values".ONLINEBACKUP, "values".DEVICEPROTECTION, "values".TECHSUPPORT, "values".STREAMINGTV, "values".STREAMINGMOVIES, "values".CONTRACT, "values".PAPERLESSBILLING, "values".PAYMENTMETHOD, "values".MONTHLYCHARGES, "values".TOTALCHARGES, "values".CHURN)] expected 19, got 20 (line 10)

Then remove the last CHURN parameter works like:

SELECT *, predict_binary_classifier("values".GENDER, "values".SENIORCITIZEN, "values".PARTNER, "values".DEPENDENTS, "values".TENURE, "values".PHONESERVICE, "values".MULTIPLELINES, "values".INTERNETSERVICE, "values".ONLINESECURITY, "values".ONLINEBACKUP, "values".DEVICEPROTECTION, "values".TECHSUPPORT, "values".STREAMINGTV, "values".STREAMINGMOVIES, "values".CONTRACT, "values".PAPERLESSBILLING, "values".PAYMENTMETHOD, "values".MONTHLYCHARGES, "values".TOTALCHARGES) AS PREDICTION 
  FROM (SELECT * EXCLUDE CUSTOMERID from CUSTOMER limit 100) as "values" ;

[helincao]

Did you train the model using CALL TRAIN_BINARY_CLASSIFIER('CUSTOMER', 'CHURN', ['CUSTOMERID']);?

[yiwang]

yes