1. Machine Learning for SQL Use Cases
  2. Concepts
  3. Machine Learning Algorithms
  4. About XGBoost
  5. Scoring with XGBoost

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)