"Regex for Rows": Simplifying Pattern Detection in SQL with MATCH_RECOGNIZE
Summary
MATCH_RECOGNIZE brings regex-style pattern matching to SQL, now in Public Preview, letting you detect sequences and patterns directly in event data. It's built for use cases like fraud detection in financial services, threat detection in cybersecurity, funnel analysis in e-commerce, and anomaly detection in manufacturing and IoT.
Summary generated by brickster.ai. For the full article, follow the source link above.
More from Databricks Blog
How energy teams turn theft detection into governed action with Genie and AI business processes
A Databricks App orchestrates the full lifecycle of energy theft detection—turning ML-flagged suspicious accounts into prioritized investigations, dispatch-ready reports, and tracked recovery workflows, with Lakebase keeping live case state and recovery totals. Genie One, Unity Catalog, Unity Gateway, and Agent Bricks tie this together on one platform, delivering trusted metrics, governed AI usage, and automated executive reporting.
How Databricks’ marketers use data 3x more with Genie, an AI analytics assistant
Databricks built Marge, an AI analytics assistant powered by Genie Agents on a governed Marketing Lakehouse, letting marketers get trusted answers to natural-language questions instead of filing repetitive analytics requests. The result: marketers now use data 3x more in decision-making, adoption tops 85% of the marketing org, and access to insights scaled without adding analytics headcount.
Managed Postgres: What Lakebase Actually Takes Off Your Plate
Lakebase runs PostgreSQL on serverless infrastructure with automatic scaling, scale-to-zero, point-in-time recovery, branching, pgvector, and PostGIS, handling most managed Postgres operations—patching, scaling, failover, backups—within a region. Cross-region disaster recovery is the one piece it doesn't fully own, still requiring customer-managed recovery procedures.
Announcing On-Demand State Repartitioning for Apache Spark™ Structured Streaming on Databricks
Databricks now supports on-demand state repartitioning for stateful Structured Streaming queries: set spark.sql.streaming.stateStore.partitions and restart on DBR 18+ with the RocksDB state store provider to redistribute state to a new partition count without rebuilding the checkpoint. This lets you resize long-running streams to match workload demands and monitor each resize through query progress metrics.
Health Plans: Your BI Tells You MLR Moved. Can Your AI Tell You Why?
Databricks and Abacus Insights combine to let payer finance teams use conversational AI to decompose MLR variances across claims, utilization, cost, and population risk in minutes instead of waiting on analyst reports. The approach embeds payer-specific business logic—covering IBNR, rebates, risk adjustment, and provider settlements—into a governed data and AI foundation so AI explains MLR shifts accurately rather than compounding confusion from inconsistent definitions across systems.
Unify your marketing data with Lakeflow Connect
Lakeflow Connect now offers native, fully managed connectors for marketing and ad platforms—including Salesforce, HubSpot, Google Ads, Meta Ads, TikTok Ads, LinkedIn Ads, Marketo, and more—landing governed data directly into Unity Catalog without any infrastructure to manage. Paired with the Ad-Genie solution accelerator, teams can turn raw ad data into a governed customer 360 and a natural-language Genie agent in just three steps.