What's New in Lakeflow Designer - October 2026 Roundup

Summary

Lakeflow Designer, a visual no-code data preparation tool in Databricks, added three new operators for cleaning, deduplication, and quality checks, addressing customer requests for more no-code capabilities. The Prepare operator standardizes data by changing case, converting types, replacing values, and applying formulas; Unique removes duplicates across selected columns with ordering control; Guardrails enforces quality rules with configurable failure handling. Existing operators gained multi-table joins with separate outputs for matched, left unmatched, and right unmatched rows, branching in Filter, and dynamic column selection in Select. Output options expanded to materialized views in Unity Catalog that refresh automatically, merge into existing tables, and direct file writes to CSV, Excel, or JSON with dynamic worksheets. Canvas improvements include a redesigned interface with better contrast and larger connection targets for large workflows, a searchable table of contents, visual version history, and live cursor presence.

Takeaways

1. 1

   Lakeflow Designer now includes no-code operators for data cleaning (Prepare), deduplication (Unique), and data quality checks (Guardrails), reducing the need for custom code.

2. 2

   The Join operator supports multi-table joins and provides separate outputs for matched, left unmatched, and right unmatched rows, enabling branching workflows.

3. 3

   Output options have been expanded to materialized views in Unity Catalog, merge into existing tables, and direct file writes to CSV, Excel, or JSON, with dynamic worksheet support for Excel.

FAQ