Introducing the New SQL Editor

Over the last few years, we've seen tremendous growth and adoption of Databricks SQL, our intelligent data warehouse purpose-built on the Data Intelligence Platform (take the product tour). Our relentless customer focus drives everything we do, helping us iterate to make you even more productive when authoring SQL. Today, we are excited to announce the Public Preview for the new SQL editor.

The new SQL editor blends the best aspects of the platform into a unified and streamlined SQL authoring experience. It also offers several improved features, including multiple statement results, real-time collaboration, enhanced Databricks Assistant integrations, and a variety of editor productivity features to take your SQL development to the next level. 

Key features

Let’s take a closer look at some of the key features.

Multiple statement results

When running multiple SQL statements at once,  you can compare the output from each statement with multiple statement results.

Improved collaboration 

Take advantage of user presence to write code and collaborate with others in real time. Add comments to ask questions or highlight key code snippets. 

New Assistant integrations

With the Databricks Assistant, you can easily leverage AI to author SQL, even if you aren’t a Databricks SQL syntax expert. With the new SQL editor, we are excited to add even more powerful assistant integrations.

Quick Fix is a powerful new feature that automatically resolves common errors, such as trailing commas, typos, and other syntax mistakes. Designed for speed, Quick Fix delivers suggestions in just 1-3 seconds and is seamlessly integrated with keyboard shortcuts.

Execute code directly in the side panel. Test code snippets or compare multiple outputs side-by-side before bringing code into the main editor. 

Quickly filter result outputs with natural language with AI-generated filters. Filters do not require statement re-execution and can be chained together to drill into specific insights.

Enhanced editor ergonomics 

Quickly perform editor actions without leaving your keyboard via the command palette. 

Code folding hides unnecessary code, allowing you to focus on what’s relevant to your current task. 

Customize your SQL editor with custom themes. You can choose from a variety of popular editor themes, including dark mode options. 

Quickly organize and navigate to other queries with the Workspace file browser.

What’s next

We’re just getting started with the new SQL editor and have many more enhancements on the roadmap. One feature coming soon is Git support for queries, enabling you to use version control and leverage CI/CD natively with SQL queries. 

Get started with the new SQL editor

The new SQL editor is available in all clouds today. To enable, open a query and click the ‘New SQL editor:OFF’ banner, and set the toggle to ON. 

Check out our documentation page for more detailed resources on getting started with the new SQL editor. 

If you have any feedback or questions, feel free to contact us via the ‘Send feedback’ links in the product or at [email protected].