Databricks SQL release notes

Preview

This feature is in Public Preview.

This article lists new Databricks SQL features and improvements, along with known issues and FAQs.

Release process

Databricks releases updates to the Databricks SQL web application user interface on an ongoing basis, with all users getting the same updates, rolled out over a short period of time.

In addition, Databricks typically releases new SQL warehouse compute versions regularly. Two channels are always available: Preview and Current.

Note

Releases are staged. Your Databricks account may not be updated with a new SQL warehouse version or Databricks SQL feature until a week or more after the initial release date.

Channels

Channels let you choose whether to use the Current SQL warehouse compute version or the Preview version. Preview versions let you try out functionality before it becomes the Databricks SQL standard. Take advantage of preview versions to test your production queries and dashboards against upcoming changes.

Typically, a preview version is promoted to the current channel approximately two weeks after being released to the preview channel. Some features, such as security features, maintenance updates, and bug fixes, may be released directly to the current channel. From time to time, Databricks may promote a preview version to the current channel on a different schedule. Each new version will be announced in the following sections.

To learn how to switch an existing SQL warehouse to the preview channel, see Use the preview channel.

Current

Version 2022.30: September 14 - October 10, 2022

  • A Single Metastore per available region is supported.

    • A Metastore can have up to 1,000 catalogs.

    • A Catalog can have up to 10,000 schemas.

    • A schema can have up to 10,000 tables.

Preview

Version 2022.35: September 14 - October 10, 2022

  • MERGE INTO now uses dynamic file and partition pruning whenever it is effective, to improve performance

  • Improved conflict detection in Delta with dynamic file pruning

  • CONVERT TO DELTA automatically infers the partition schema for Parquet tables

  • Table schemas now support default values for columns

  • Serverless: You can now use 28 new built-in H3 expressions for geospatial processing. See H3 geospatial functions.

  • SQL: New aggregate function any_value

Web application user interface updates

The features listed in this section are independent of the SQL Warehouse compute versions described in the Channels section of the release notes.

September 22, 2022

Improvements:

  • Counter widgets of the same size will have the same font sizing when multiple counter widgets are displayed on a dashboard.

  • Updated combination charts so that when using dual axis, only the same chart type (e.g., line, bar) can be used on the same axis. Series aliases are also applied to the axis.

  • Added autocomplete support for surrogate keys and LIST operations.

Fix:

  • Fixed issue where text parameters did not accept Null as a valid value.

September 15, 2022

Fix:

  • Fixed an issue where viewing query history from the SQL warehouses listing page did not work.

September 8, 2022

Improvement:

  • Introducing the new ‘Open Source Integrations’ card in DSE/SQL homepages that displays open source integration options such as Delta Live Tables and dbt core.

Fix:

  • Fixed an issue where parameter dropdown menus were blocked by the visualization tab.

September 1, 2022

Improvements:

  • Introducing a new simplified UI to add parameters and filters. Choose <button>+</button> and choose to add a filter or parameter.

  • The parentheses of SQL tokens, such as ‘OVER()’ now get autocompleted.

Fixes:

  • Fixed an issue where viewing the dashboard in full-screen ignored the color palette.

  • Fixed an issue where typing quickly and then using the Run shortcut ran the previous query text, instead of the newly typed query text.

  • Fixed issue where using the keyboard command, ctrl+enter to run queries would submit duplicate queries.

August 25, 2022

Fix:

  • Fixed an issue where dashboard filters were not updating when query parameters changed.

August 18, 2022

  • Documentation: Alerts API documentation has been released.

  • Visualizations: Users can now set default values for date filters. Any time the filter is refreshed on a query or dashboard, the default value is applied.

  • Fixes:

    • Fixed an issue where apply changes did not work if a dashboard was still reloading.

    • Fixed an issue where columns were too narrow when a query returns no results.

August 11, 2022

Improvements:

  • Users can receive emails when their refreshes fail. To enable such notifications, log in as a SQL Admin and navigate to the SQL Admin Console. Under Failure Emails, choose the type of object (Query, Dashboard, or Alert) for which you wish to receive failure notifications. Failure reports are sent hourly.

  • Visualizations

    • Introducing a new, modern color palette for visualizations and dashboards. To change a dashboard to the new color palette, go to your dashboard, click on <button>Edit</button> -> <button>Colors</button> -> <button>Import</button> and select the Databricks Color Palette. SQL Admins can also set the new color palette as the default option for a workspace by going to <button>Settings</button> -> <button>QL Admin Console</button> -> <button>Workspace Colors</button> -> <button>Import</button> and selecting the new palette.

Fixes:

  • Fixed an issue where previously selecting <button>Apply Changes</button> to apply a filter did not work if a query was already being executed.

August 4, 2022

Improvements:

  • On cloning a dashboard, there is now an option for whether or not queries should be cloned as well.

  • Tab content is synced across browser tabs. The state of your query will now be in sync across all browser tabs. This means that if you are working on query1 in browser tab 1 and then switch to browser tab 2, you’ll see query1 in the state you left it in while in the original browser tab.

Fix:

  • Labels for empty strings in pie chart now reflect that the string is empty rather than the index of the value.

July 28, 2022

  • Alerts

    • Custom alert email templates have been updated to disallow certain HTML tags that may pose a security risk. As an example, button isn’t an allowed HTML tag. So if users have a <button>Click here</button> in their custom alert body, instead of seeing Click here in their email, they will see <button>Click here</button> in their email. See Alerts for the list of allowed HTML tags and attributes.

    • Users can now add emails as alert destinations without requiring admin permissions. Recipients must be other users in the same workspace.

  • Downloads: Users can now download up to approximately 1GB of results data from Databricks SQL in CSV and TSV format, up from 64,000 rows previously.

  • Visualizations

    • You can now edit visualizations directly on the dashboard. In edit mode, click on the kebab menu and select Edit visualization to begin editing the visualization.

    • When downloading results associated with a visualization leveraging aggregations, the downloaded results are also aggregated. The option to download is moving from bottom kebab to the kebab associated with the tab. The downloaded results are from the most recent execution of the query that created the visualization.

  • SQL Editor: Results tables now display a message when data displayed by the in-browser table has been limited to 64,000 rows. TSV and CSV download will still be up to approximately 1GB of data.

  • Query filters:

    • Query filters have been updated to work dynamically on either client- or server-side to optimize performance. Previous query filters (now legacy) operated client-side only. Users can still use legacy filters with the :: syntax, if desired.

    • The updated filters are simpler: Users click a +Add Filter button and select a column from a dropdown. Previously, users had to modify the query text directly.

    • Relevant values are highlighted to make it easier to see which selections within a filter will return results given other filter selections.

  • Query history: Query details in Query History now show the Query Source, which is the origin of the executed query.

July 21, 2022

  • Notifications on share: Users will now be notified by email whenever a dashboard, query, or alert is shared with them.

  • Enhanced SQL editor experience via the new embedded editor toolkit

    • Live syntax error highlighting (for example, wrong keyword, table does not exist, and suggestions for fixing the error)

    • In context help: on hover (for example, full table name, detailed Function panel) and inline execution error messages (for example, highlight row with error post execution)

    • Intelligent ranking of suggestions (for example, parameter autocompletion, ranking formula, less noisy matching)

July 14, 2022

  • You can now upload TSV files using the Create Table UI in addition to CSV files.

  • Databricks SQL now provides the option to notify users by email whenever a dashboard, query, or alert is shared with them.

  • Visualization tables now optionally include row numbers displayed next to results.

  • When you select a geographic region for the Chloropleth visualization, you now get inline hints for accepted values.

June 23, 2022

  • SQL endpoint name change: Databricks changed the name from SQL endpoint to SQL warehouse because it is more than just an API entry point for running SQL commands. A SQL warehouse is a computation resource for all your data warehousing needs, an integral part of the Lakehouse Platform. Compute resources are infrastructure resources that provide processing capabilities in the cloud.

  • For Choropleth visualizations, the Key column and Target field selections in the visualization editor have been renamed to Geographic Column and Geographic Type. This renaming for understandability does not introduce any behavior changes to new or existing Choropleths.

  • The limit 1000 query option has moved from a checkbox in the SQL query editor to a checkbox in the run button.

  • Cached queries in Query History table are now marked with a Cache tag.

  • Manually refreshing a dashboard uses the dashboard’s warehouse (if available) instead of each individual query’s warehouse.

  • Refreshing an alert always uses the alert’s warehouse, regardless of the Run as Viewer/Owner setting.

June 9, 2022

  • When you hover in the endpoint selector, the full endpoint name is displayed as a tooltip.

  • When you filter in the SQL Editor schema browser, the search term is now highlighted in the search results.

  • The Close All dialog box in the SQL Editor now displays a list of unsaved queries.

  • To reopen the last closed tab in the SQL Editor, use this new keyboard shortcut: <Cmd> + <Shift> + <Option> + T

  • You can now add data labels to combination charts.

  • The list of visualization aggregations operations now includes variance and standard deviation.

May 26, 2022

Authoring improvements:

  • You can now bypass aggregations when you author visualizations. This is particularly useful when your query already includes an aggregation. For example, if your query is SELECT AVG(price_per_sqft), isStudio, location GROUP BY location, isStudio, the chart editor previously required explicitly specifying another layer of aggregation.

  • When you author dashboards, you now have the ability to:

    • Duplicate textbox widgets

    • Expand the size of the edit textbox panel

  • The default aggregation for the error column when you author visualizations is standard deviation.

Fixes:

  • Edit actions for visualizations are only available when the dashboard is in edit mode. Edit actions are no longer available as a view mode action.

  • When you create a new query, it opens in a tab to the immediate right of the tab in focus rather than at the end of the list.

  • The open query modal shows which query is already open and provides the option to switch focus to that query tab.

  • The Sankey & Sunburst charts no longer treat 0 as null.

May 19, 2022

  • Fixed issue: When you have the focus of the SQL Editor open on a specific visualization tab and share the link to another user, the user will have the same focus in the SQL Editor when they click the shared link.

  • Improvements:

    • Microsoft Teams is now a supported alert destination.

    • The Date Range, Date and Time Range, and Date and Time Range (with seconds) parameters now support the option to designate the starting day of the week, with Sunday as the default.

May 12, 2022

  • Visualizations now support time binning directly in the UI. You can now easily switch between yearly, monthly, daily, or hourly bins of your data by changing a dropdown value rather than adding and modifying a date_trunc() function in the query text itself.

  • Dashboards now have color consistency by default. If you have the same series across multiple charts, the series is always colored the same across all charts – without requiring any manual configuration.

May 3, 2022

  • When sharing a dashboard with a user or group, we now also provide the ability to share all upstream queries used by visualizations and parameters.

    • When you do not have permission to share one or more of the upstream queries, you will receive a warning message that not all queries could be shared.

    • The permissions granted when sharing a dashboard do not override, negate, or expand upon existing permissions on the upstream queries. For example, if a user or group has Can Run as Owner permissions on the shared dashboard but only has Run as Viewer permissions on an upstream query, the effective permissions on that upstream query will be Run as Viewer.

April 27, 2022

  • Your dashboard layout is now retained when exporting to PDF on demand and generating scheduled subscription emails.

April 25, 2022

  • Databricks SQL is now available in Public Preview on Google Cloud Platform.

Known issues

  • Reads from data sources other than Delta Lake in multi-cluster load balanced SQL endpoints can be inconsistent.

  • Delta tables accessed in Databricks SQL upload their schema and table properties to the configured metastore. If you are using an external metastore, you will be able to see Delta Lake information in the metastore. Delta Lake tries to keep this information as up-to-date as possible on a best-effort basis. You can also use the DESCRIBE <table> command to ensure that the information is updated in your metastore.

  • Databricks SQL does not support zone offsets like ‘GMT+8’ as session time zones. The workaround is to use a region based time zone https://en.wikipedia.org/wiki/List_of_tz_database_time_zones) like ‘Etc/GMT+8’ instead. See SET TIME ZONE for more information about setting time zones.

Frequently asked questions (FAQ)

How are Databricks SQL workloads charged?

Databricks SQL workloads are charged according to the Premium Jobs Compute SKU.

Where do SQL endpoints run?

Like Databricks clusters, SQL endpoints are created and managed in your Google Cloud account. SQL endpoints manage SQL-optimized clusters automatically in your account and scale to match end-user demand.

I have been granted access to data using a cloud provider credential. Why can’t I access this data in Databricks SQL?

In Databricks SQL, all access to data is subject to data access control, and an administrator or data owner must first grant you the appropriate privileges.