teradata-labs Teradata ROC Curve Analysis
| Property | Value |
|---|---|
| Skill Name | Teradata ROC Curve Analysis |
| Description | ROC curve and AUC analysis for binary classification evaluation |
| Category | Model Evaluation |
| Primary Function | TD_ROC |
| Framework | SQLE |
Core Capabilities
- Automated table structure analysis via DBC.ColumnsV
- Dynamic SQL generation for TD_ROC
- Complete workflow from data preparation to results interpretation
- Data quality validation and preprocessing guidance
- Parameter optimization and tuning
Key Parameters
- ProbabilityColumn: Column with predicted probabilities
- ObservationColumn: Column with actual class labels
- PositiveClass: Value representing the positive class
- NumThresholds: Number of threshold points (default 50)
Use Cases
- Binary classifier performance evaluation
- Threshold selection optimization
- Model comparison via AUC
- Trade-off analysis between TPR and FPR
Example Usage
-- TD_ROC execution
SELECT * FROM TD_ROC (
ON {USER_DATABASE}.{PREDICTION_TABLE} AS InputTable
USING
ProbabilityColumn ('{PROBABILITY_COLUMN}')
ObservationColumn ('{ACTUAL_LABEL_COLUMN}')
PositiveClass ('{POSITIVE_CLASS_VALUE}')
NumThresholds (50)
) AS dt;
Scripts Included
Core Analytics Scripts
table_analysis.sql: Automatic table structure discoverypreprocessing.sql: Data preparation and feature engineeringmodel_training.sql: TD_ROC executionevaluation.sql: Results analysis and metricscomplete_workflow_template.sql: End-to-end workflow
Utility Scripts
data_quality_checks.sql: Comprehensive data validationparameter_tuning.sql: Parameter optimizationdiagnostic_queries.sql: Results diagnostics and interpretation
Best Practices
- Always run table_analysis.sql first to understand your data structure
- Validate data quality before executing the analytical function
- Use parameter_tuning.sql to find optimal configuration
- Review diagnostic_queries.sql output for model/results validation
Limitations
- Requires Teradata Vantage 17.20+ with ClearScape Analytics
- Input data must meet function-specific requirements
- Results depend on data quality and parameter configuration
Teradata ROC Curve Analysis - ClearScape Analytics skill for Teradata Vantage