View query results in the new SQL editor

The new Databricks SQL editor lets you view, visualize, download, copy, and filter query results, with CSV, TSV, and Excel exports up to 5GB.

View query results

You can compare the output from each statement with multiple result statements. When you run multiple SQL statements from a single edit window, you can use the UI in the Output pane near the bottom of the page to scroll through the different result sets.

You can interact with and explore your query results using the result pane. The result pane includes the following features for exploring results.

Visualizations

Click the to open the Visualization Editor. Visualizations can help explore the result set. See Notebook and SQL editor visualization types for a complete list of available visualization types.

Click the on a visualization tab to show additional options.

• Click Download to download the data represented in the visualization as a CSV, TSV, or Excel file.
• Click Remove to delete the visualization.
• Click Duplicate to clone the results tab.
• Click Rename to retitle the visualization.

1. Click Edit to edit the visualization.
2. Click Add to dashboard to copy the query and visualization to a new AI/BI dashboard.
3. Select Create new dashboard or Add to existing dashboard.
   • Create new dashboard: Creates a new dashboard that includes all the visualizations associated with the query. You are prompted to choose a name for the new dashboard. The new dashboard is saved to your Home folder.
   • Add to existing dashboard: Adds your query and associated visualizations to an existing dashboard. Use the drop-down menu to choose the dashboard that the data set and visualization should be added to.

Download and copy results

You can download results as a CSV or Excel file. Click the in a Table tab to view download options. You can also copy results to your clipboard using this menu.

You can download up to approximately 5GB of results data in CSV, TSV, or Excel format. The downloaded file might be slightly larger or smaller than 5GB, because Databricks applies the limit before generating the final file.

To copy a smaller selection of rows from your query results, select the rows in the results table, right-click, and select Copy.

When you display, download, or copy query results, NULL values appear as the literal string null rather than as empty cells. To represent NULL values as empty cells instead, wrap columns in COALESCE with an empty string, for example COALESCE(column_name, ''). Non-string columns must be cast to a string first, for example COALESCE(cast(column_name as string), '').

Before COALESCE	After COALESCE

Filters

Filters allow you to limit the result set after a query has run. You can apply filters to selectively show different subsets of the data. Use Genie Code to help you add a filter for results.

To add a filter:

1. Click the filter icon.
2. Enter text to describe the kind of filter you want to apply. A named filter is applied to the result set.

To edit a filter:

1. Click the name of the filter.
2. Use the drop-down menus and text fields to adjust the filter settings.
3. (Optional) Select Case senstitive to make the filter case sensitive.
4. (Optional) Click Add OR condition to add an additional filter.

Supported filter types

The following table shows filter types supported in the new SQL editor. The second column indicates whether the filter also works in the legacy SQL editor.