Scoring with XGBoost

Score with XGBoost using the supported SQL functions to predict values.

The SQL scoring functions supported for a classification XGBoost model are PREDICTION, PREDICTION_COST, PREDICTION_DETAILS, PREDICTION_PROBABILITY, and PREDICTION_SET.

The scoring functions supported for a regression XGBoost model are PREDICTION and PREDICTION_DETAILS.

The prediction functions return the following information:

  • PREDICTION returns the predicted value.
  • PREDICTION_COST returns a measure of cost for a given prediction as an Oracle NUMBER. (classification only)
  • PREDICTION_DETAILS returns the SHAP (SHapley Additive exPlanation) contributions.
  • PREDICTION_PROBABILITY returns the probability for a given prediction. (classification only)
  • PREDICTION_SET returns the prediction and the corresponding prediction probability for each observation. (classification only)