topic Re: Use API to Clone Dashboards with Widgets in Databricks SQL? in Data Engineering

Use API to Clone Dashboards with Widgets in Databricks SQL?

bl12 — Tue, 26 Jul 2022 19:45:49 GMT

Hi, I manually created a template dashboard with one widget. I wanted to clone this dashboard using the Create Dashboard API however I don't know what to put for the widget object. What I did was use the Retrieve API on the template dashboard, and then copied the widget information to Create Dashboard API. But this just made a new dashboard with no widgets so how do you clone the widget too using the API?

Additionally, if it's possible to do that, would I be able to change the underlying query powering the widget on the cloned dashboard in the Create API?

https://docs.databricks.com/sql/api/queries-dashboards.html#operation/sql-analytics-create-dashboard

Re: Use API to Clone Dashboards with Widgets in Databricks SQL?

User16752242622 — Wed, 24 Aug 2022 10:39:22 GMT

Hi @Belle L

Please try submitting a POST request to /api/dashboards/{dashboard id}/clone API

with a JSON request body like so:

{"name": "<desired name of new dashboard>"}

I believe, this way you can have a duplicate of the existing dashboard and widgets.

This is not documented yet. We have an internal ticket on this API to update the document.

Hope this helps!

Best,

Akash

Re: Use API to Clone Dashboards with Widgets in Databricks SQL?

Wout — Tue, 15 Nov 2022 06:42:45 GMT

@Akash Bhat how do I clone a dashboard across workspaces? Being able to deploy dashboards (with widgets!) through the API is essential to set up proper Data Engineering workflows.