Convert proprietary code to open ANSI SQL with Genie Code
Summary
Now in Beta, Genie Code powers an agentic converter that launches swarms of parallel agents to translate proprietary SQL into open ANSI SQL, iteratively validating both syntax and semantic intent. It covers T-SQL, Snowflake, Redshift, Oracle, BigQuery, and Teradata sources, with migration projects in the Databricks workspace to track progress, visualize lineage, and identify objects that need to move together.
Summary generated by brickster.ai. For the full article, follow the source link above.
More from Databricks Blog
Quality care is the mission. Finance protects the margin.
Quality care is the mission. Finance protects the margin — while revenue-side functions like coding, adjudication, and denials get faster and more complex through AI and agents, finance teams are still working from fragmented systems and weeks-old data. This post argues that Databricks Genie closes that gap as a governed, ontology-grounded AI coworker that answers the three core finance questions — cost-to-reimbursement gaps, denials/underpayments, and trapped cash — with every figure traced to source and correct, not just accurate, in business context.
Energy runs on volatile markets. Finance protects the margin.
Energy finance runs on a data ontology that keeps margin figures tied to their business context—asset, market, contract—as prices, positions, and the forward curve shift throughout the day. Databricks' Genie AI coworker builds on that foundation to give finance teams governed, traceable answers on margin exposure, revenue risk, and funding capacity for AI-driven power demand.
Manufacturing runs on capital. Finance protects the margin.
Manufacturing locks an estimated $1.7T in excess working capital across large US companies, trapped in inventory, receivables, and equipment; finance's job is freeing that cash, and AI agents are making that job both faster and more complex. The post argues an ontology is what makes a number trustworthy in business context, and shows how Genie acts as a data-smart finance coworker, surfacing where cash is trapped, where receivables are aging, and which assets underperform with governed, traceable answers.
Bringing real-time fraud prevention to government benefits
Databricks is helping federal agencies move fraud detection for benefit programs from after-the-fact reviews to real time, building on techniques honed with banks, credit card companies, and insurers. With over 80% of federal executive departments already on the platform, tools like OpenSharing and Clean Rooms let agencies share fraud signals across silos without exposing raw data, surfacing schemes no single agency could catch alone.
Agents for production lines: Trusted decisions in real time
Agents like ProdLine CoPilot analyze live plant state from the Databricks Data Intelligence Platform to turn line-manager recovery decisions from a next-morning report into an in-shift answer. Zerobus streams OT telemetry into Delta tables alongside MES, ERP, and LIMS under Unity Catalog, so domain specialists can run real solvers against planners' existing constraints while recommendations stay as draft work orders and holds pending human approval.