Dashboard update through API

[pawelzak]

Hi,

I would like to create / update dashboard definition based on the json file. How can one do it? I tried the following:

1. databricks api post /api/2.0/preview/sql/dashboards/$dashboard_id --json @file.json
   But it does not update the widgets
2. databricks api get /api/2.0/workspace/export --json '{"path": "/Shared/t1"}'
   Got the following result: "Error: dbsqlDashboard is not user-facing."

How can this be solved, I need to be able to create / update the dashboards programatically...

Regards,

Pawel

[Kaniz]

Hi @pawelzak, Databricks does not currently support creating or updating dashboards directly from a JSON file via....

For creating or updating resources in Databricks, you might want to look into the Databricks REST API. For instance, the Workspaces - Create Or Update - REST API allows you to create a new workspace. However, this might not directly apply to your use case of updating dashboards.

If you’re trying to create tables based on a JSON config, you could consider using PySpark in Azure .... You can iterate through the JSON (dict) and create the table. 

[pawelzak]

Hi @Kaniz,

This situation presents significant challenges for our organization. How can we replicate dashboards across workspaces? Are there alternatives such as SDKs, Terraform, or anything similar? This seems like a fundamental use case, and it's surprising that Databricks doesn't support it, especially considering that extracting the definition is possible.

Apologies for creating duplicate tickets, but I've observed that follow-up questions often go unanswered in the Databricks community threads and this issue is critical for my organization.

Thank you,

Pawel