Skip to the content.

← Daily Brief for October 20, 2026

Predictive functions move model judgment into SQL

Focus: Applied Generative AI for Knowledge Workers
Date: October 14, 2026
Topics: Predictive SQL, Forecast evaluation, Analyst workflows
Evidence: Publisher Authored
Availability: Available

Five predictive SQL methods connect to governed data, with holidays and covariates feeding forecast. A separate recommended validation path shows backtests, baseline comparison and uncertainty review, beside current and forthcoming Genie availability.

Summary: Databricks introduced beta SQL functions for forecasting, driver analysis, anomaly detection, regression and classification, with results usable in queries, dashboards and Genie. Its examples show holidays and business covariates informing forecasts. Accuracy comparisons use a named benchmark, but the platform maintains the models and reports the results, so teams still need local baselines and error review.

Why it matters: Give analysts one governed dataset and prediction question, then compare the built-in function with an approved baseline across backtests, missing data and business shocks. Require visible inputs, uncertainty, refresh rules and an escalation path before decisions depend on results.

Source: Unlock powerful insights and forecasts with Predictive AI Functions


← Daily Brief for October 20, 2026