Sunday, November 22, 2026Coding news · developer employment · the CodeCore archive · RSS
CodeCoreCoding news, employment and the Vancouver tech community

Databricks SQL AI Forecast V2 Adds Holiday Support and Covariates

Databricks SQL's ai_forecast function now supports holiday effects and covariates, streamlining time-series forecasting directly within SQL queries.

· DEV Community

SAN FRANCISCO — Databricks SQL has enhanced its ai_forecast function with version 2, introducing support for holiday effects, covariates, and non-negative forecasts. This update allows developers to generate more accurate time-series predictions without leaving their SQL workflows, eliminating the need for data export and custom model training.

The ai_forecast function operates as a table-valued function, enabling users to call it directly in the FROM clause of a SQL query. It processes historical data and returns forecasted values with confidence intervals, which can then be filtered, joined, or saved like any other table. This makes it ideal for scenarios where data is already stored in tables and quick, general-purpose forecasts are needed.

Key improvements in version 2 include the ability to account for holiday effects by passing region codes (e.g., 'US') and incorporating covariates like promotional flags. Testing revealed that including planned promotions significantly boosted forecast accuracy, outperforming gains from the model itself. The function also now supports non-negative forecasts, ensuring realistic predictions for metrics like sales or demand.

While ai_forecast simplifies forecasting for common use cases, Databricks recommends custom models for scenarios requiring specialized features or fine-tuned control. The function is particularly useful for dashboards, scheduled queries, or pipeline steps where speed and simplicity are prioritized. Developers can access the complete guide and sample code on GitHub to integrate these features into their workflows. Reported with files from DEV Community.

News

Critical Check Point Vulnerability CVE-2026-123039 Exploited in PHP2Shell Campaign

· DEV Community

Security researchers detail post-exploitation evidence and recovery steps for the exploited Check Point CVE-2026-123039 vulnerability with CVSS 7.8 score.

News

Developer Reveals Method for Scraping App Store Reviews Without Proxies

· DEV Community

A Node.js developer shares a technique for extracting international App Store review data in JSON format, enabling sentiment analysis without complex scraping infrastructure.

News

How a WordPress LMS Front End Was Rebuilt with React and Cloudflare Pages

· DEV Community

A team modernized a WordPress LMS front end using React and Cloudflare Pages while maintaining core functionality like logins and payments.

News

Inkling 2 Mini Brings Looped AI Model to Local Development

· DEV Community

Thinking Machines Lab releases Inkling 2 Mini, a locally runnable multimodal AI model with a unique looped architecture for coding and tool use.