Clone a Databricks SQL dashboard to a Lakeview dashboard

Preview

This feature is in Public Preview.

This article describes how to create a new draft Lakeview dashboard by cloning an existing Databricks SQL dashboard. Lakeview dashboards are intended to replace Databricks SQL dashboards. Clone to Lakeview dashboard is a menu option in the UI that simplifies the conversion process.

Using this button to create a new Lakeview dashboard does not affect the original Databricks SQL dashboard or queries. Instead, this process uses the underlying queries and widget settings to create an equivalent Lakeview dashboard.

Note

Lakeview dashboards do not support all Databricks SQL functionality. See What are Lakeview dashboards? to learn about the available features in Lakeview dashboards.

Required permissions

You must have at least Can View permission on the Databricks SQL dashboard and all upstream queries, including those backing query-based dropdown list parameters. Databricks SQL handles permissions for queries and dashboards separately. Insufficient permissions on an upstream query causes the clone operation to fail.

Clone to Lakeview dashboard

The following animation shows a successful conversion.

Gif showing conversion process

Complete the following steps to clone a dashboard:

  1. Click Clone to Lakeview Dashboard.

    You can access the Clone to Lakeview Dashboard option from the following areas in the UI:

    • The Workspace file browser.

      Right-click on the dashboard title, then click Clone to Lakeview dashboard. Alternately, use the Kebab menu kebab menu to access the same option.

      Menu options shown on right-click from the Workspace file browser
    • An existing Databricks SQL dashboard.

      Click Clone to Lakeview dashboard from the Kebab menu kebab menu on an existing Databricks SQL dashboard.

  2. (Optional) Specify a title and folder location for the new dashboard.

    By default, you save the new dashboard in the same folder as the original Databricks SQL dashboard, with (Lakeview) appended to the original title. At this stage, you can retitle the new dashboard and choose a different destination folder.

  3. Click Clone.

    Success message with link to new dashboard.

After the operation completes, look for a notification in the screen’s upper-right corner. Use the link to navigate to your new Lakeview dashboard.

Review cloned dashboard results

A successful cloning operation creates a new draft Lakeview dashboard. The existing Databricks SQL dashboard and related queries remain unchanged. The two dashboards are unrelated. Updates to one dashboard do not affect the other.

The new Lakeview dashboard is created as a draft. It inherits any sharing permissions applied at the folder level. Permissions set on the source dashboard are not propagated. See Share workspace objects using folders.

All Lakeview drafts are automatically granted Run as Viewer credentials, regardless of existing credential settings in the original Databricks SQL dashboard. When you publish a Lakeview dashboard, you can choose to embed credentials or not. This affects how other users view and interact with your dashboard. See Share Lakeview dashboards to learn how to share and manage permissions for published Lakeview dashboards.

Troubleshooting and manual adjustments

Lakeview dashboards do not support all features or chart types available in Databricks SQL dashboards. When you clone a Databricks SQL dashboard with unsupported elements, the new Lakeview dashboard shows an error message instead of a copy of the original widget.

Lakeview dashboard including widgets with errors.

See Lakeview dashboard visualization types to learn how to use chart types supported in Lakeview dashboards.

Queries with parameters

Lakeview does not support parameters. While the clone succeeds in recreating the target query, the query will not run until manually adjusted not to use a parameter. See Query parameters.

To modify the queries associated with a Lakeview dashboard, click the Data tab in the upper-left corner. Click the Dataset you want to change and edit the query. Run your query to check the results.