What's New in Lakeflow Designer - October 2026 Roundup

What's New in Lakeflow Designer - October 2026 Roundup | Databricks Blog Skip to main content

Summary

New and enhanced operators support data cleaning, deduplication, quality checks, more flexible joins, and parameterized inputs and outputs.

Expanded output options and canvas improvements add materialized views, table merges, file exports, visual version history, and live cursor presence.

Upcoming features include Databricks Apps integration, data profiling on full outputs, a Custom Report operator, and native migration tooling with Lakebridge.

We launched Lakeflow Designer to general availability in June, and since then, over 3,000 customers have used it to address one of the biggest bottlenecks in working with data: the technical barrier to entry. Teams migrating from legacy self-service data preparation tools have streamlined governance, simplified their data stacks, accelerated their path to production, and cut costs dramatically. With consumption-based pricing and no per-user licensing fees, we’ve seen many customers reduce their spend on no-code tooling by 90% after adopting Lakeflow Designer. Working closely with these customers has helped us identify ways to make Designer even more useful. Our latest updates bring new no-code operators, enhancements to existing operators, more output options, and an improved canvas for building and managing larger workflows. Built directly in Databricks, Lakeflow Designer is a visual, no-code, AI-native experience for data preparation and analytics. It lets analysts, domain experts, and other less technical users prepare and explore data through a drag-and-drop canvas and natural language. What’s New? Here are some of our favorite enhancements we've made to Lakeflow Designer over the last 4 months. New no-code operators for data cleaning and quality checks Genie Code, Python, and SQL operators have always made Designer flexible. However, we heard from early customers that they wanted more no-code ways to handle common tasks like deduplication, data cleaning, and data quality checks. Prepare operator: Clean and standardize data Clean and standardize your data with the Prepare operator. Change text case, convert data types, replace values, apply formulas, and more, all in a single operator. Learn more about Prepare . Unique operator: Remove duplicate records Quickly remove duplicates across the entire dataset or a selected set of columns. Set an order to control which record you keep, such as the most recently updated record for each customer. Learn more about Unique .

Guardrails operator: Add data quality checks Add data quality checks directly to your workflow with Guardrails. Check for missing values, duplicates, unexpected values, and more, then choose how failures affect the workflow: continue with passing rows, block the passed output, or stop execution. Learn more about Guardrails .

Enhancements to the existing Join, Filter, and Select operators We’ve expanded existing operators to better handle advanced use cases and branching. Split and multi-join The Join operator now provides separate outputs for matched, left unmatched, and right unmatched rows by default, allowing you to branch workflows and trigger alerts on unexpected values. It also supports joining more than two tables in a single operator. Learn more about Join .

Dynamic column selection Select columns by data type, name pattern, or formula, so your workflow adapts as the input schema changes. For example, keep every column whose name starts with sales_ , including new matching columns added later. Learn more about Select .

Parameterize inputs and outputs Source and Output operators now support parameters in their configuration, letting you change these values without reconfiguring the operator. Parameters can be overridden based on individual schedules, such as runs in test and production environments. Learn more about parameters .

Branching in the Filter operator The Filter operator now has separate outputs for rows that match your conditions and rows that don't. Use both outputs to build separate processing paths from a single filter. Learn more about Filter .

Expanded outputs for materialized views, tables, and files The Output operator now gives you more ways to save results, update existing data, and create files for downstream use. Create materialized views Write your results as a materialized view in Unity Catalog for fast computation in downstream processes like AI/BI Dashboards or even other visual data prep files. The view refreshes automatically when your visual data prep runs. Learn more about materialized view outputs .

Merge into existing tables Keep an existing table up to date by merging results using the keys you specify. Matching records are updated, and new records are inserted. You can also append results to the end of an existing table. Learn more about table outputs .

Write directly to files Write CSV, Excel, or JSON files directly to Unity Catalog volumes. For Excel outputs, you can also write dynamically to different worksheets. Learn more about file outputs .

Canvas improvements for large workflow navigation and collaboration We've updated the canvas to make larger workflows easier to navigate, understand, and maintain. Navigate larger workflows with a visually redesigned canvas The canvas has a refreshed design with more visual contrast, larger connection targets, and clearer cues for unconfigured operators and missing inputs. We've also improved scrolling and panning on canvases with 1000s of operators, making large workflows more responsive to navigate.

Find operators with a searchable table of contents Find any operator using the new searchable table of contents, then select it to jump to its location on the canvas. You can also expand its Generated code section to inspect the underlying code.

Review workflow changes with a visual version history See what changed between versions directly on the canvas. Version history now highlights operators that were added, removed, or modified, making workflow changes easier to review. Learn more about version history .

Follow collaborators with live cursor presence Live cursor presence lets you collaborate and follow what coworkers are doing when you're working in the same visual data prep file.

What’s next for Lakeflow Designer? We are continuing to invest in making Lakeflow Designer the best self-service data preparation and automation tool to work with...