METRICS

METRICS(X): This function displays performance metrics for trained ML models. For classification tasks, these metrics are accuracy, logloss, and AUC. For regressions tasks, these metrics are MAE, MSE, RMSE, and R-Squared. This is a table-valued function (TVF). It should be used in a FROM clause. The argument for this function should be either the name of the trained model or a string literal. String literal arguments support wildcards, enabling this function to display the metrics for multiple ML models in one table.

Syntax

SELECT <COLUMNS> FROM METRICS(<MODEL> | <STRING>);

Args

model or str (literal)

The name of the trained model for which to retrieve metrics. If X is a string literal, then wildcards may be used. In that case, the metrics for all matching model names are displayed in the table.

Examples

CREATE MODEL my_model AS SELECT * FROM train_data;
SELECT * FROM METRICS(my_model);

-- Fetch metrics for multiple models with a wildcard
CREATE MODEL my_model_v1 AS SELECT * FROM train_data_1;
CREATE MODEL my_model_v2 AS SELECT * FROM train_data_2;
SELECT * FROM METRICS('my_model_v*');

Introduction

Statements and Ops

Limitations

Syntax

Args

Examples

​Syntax

​Args

​Examples

Syntax

Args

Examples