Skip to main content
Last updated on

View query results in the new SQL editor

This page explains how to work with query results in the new Databricks SQL editor, including visualizations, downloads, and filters.

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.

Tabbed output pane in the new SQL editor with multiple result tables that you can move through.

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 Plus Sign Icon 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 Down Caret on a visualization tab to show additional options.

Options to customize a visualization or add to a dashboard.

  • 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 results​

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

You can download up to approximately 1GB of results data in CSV or TSV format and up to 100,000 rows to an Excel file. The final file download size might be slightly more or less than 1GB, because the 1GB limit is applied to an earlier step than the final file download.

Options to download or copy results.

note

If you cannot download a query, your workspace administrator has disabled download for your workspace.

Copy selected results​

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

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 Filter icon. 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.

Filter type

Supported in legacy editor

Is equal to

Yes

Is not equal to

No

Is one of

Yes

Is not one of

No

Contains

Yes

Does not contain

No

Starts with

Yes

Does not start with

No

Ends with

No

Does not end with

No

Is null

No

Is not null

No

Greater than

No

Greater than or equal to

No

Less than

No

Less than or equal to

No

Between

Yes

Before

No

After

No

Is true

Yes

Is false

Yes

OR conditions

No

On this page