topic Re: How to let Business Users edit tables in Databricks in Warehousing & Analytics

How to let Business Users edit tables in Databricks

DataFarmer — Mon, 26 Feb 2024 15:07:35 GMT

Hi Community!

I have the requirement that business users shall be able to edit/update tables in Unity Catalog, e.g. master data records, mapping tables. I also want thes actions to be logged for auditing/troubleshooting.

Is there any simple solution to do this in Databricks that fits for non-technical people?

Re: How to let Business Users edit tables in Databricks

DataFarmer — Mon, 26 Feb 2024 16:28:45 GMT

My own ideas:

- share a notebook with business users to update tables (risky)

- create a low-code app with write permission via sql endpoint

- file-based interface for table changes (ugly)

Any other ideas on existing market solutions for this would be really appreciated.

Re: How to let Business Users edit tables in Databricks

kenwong — Tue, 27 Feb 2024 23:15:47 GMT

We do have a few partners that offer solutions in this space (e.g. Retool). Recently, Sigma added support for their InputTable feature which was designed for this use case: https://www.sigmacomputing.com/blog/bring-your-own-data-to-databricks-with-sigma-input-tables

Re: How to let Business Users edit tables in Databricks

JenStephens — Wed, 18 Sep 2024 19:35:53 GMT

Are there any plans to offer this as a feature from within Databricks without a third party tool?

Re: How to let Business Users edit tables in Databricks

Husky — Wed, 25 Sep 2024 10:24:08 GMT

Currently Databricks has Lakehouse Apps in private preview, where you can build low-/no-code apps upon your data directly in Databricks: https://www.databricks.com/company/newsroom/press-releases/databricks-announces-lakehouse-apps-and-expands-databricks
I don't know if databricks will offers its own app builder, but you can use and administrate tools like Retool or Gradio directly inside of databricks.

I hope that helps.

Re: How to let Business Users edit tables in Databricks

Wikram — Wed, 12 Feb 2025 04:39:21 GMT

Have u figured out any solution. Can u share it here.?

Re: How to let Business Users edit tables in Databricks

Junpei_Liang — Wed, 02 Apr 2025 20:25:45 GMT

Just checking in to see if there are any new updates on this.