User entry via portal/UI

[Viren123]

Hello Experts,

We have data bricks on Azure. We need to provide a user interface to users so that some customizing table entries can be entered by end users which in turn are saved in the Delta table. Is there any feature in Databricks or tools that we can use to do this in easy manner. We prefer easy method if possible.

Thank you

Viren

[Hubert-Dudek]

• use git and save it as CSV and JSON, mount that repo in databricks,
• save as Excel or CSV on onedrive and set Power Automate Flow or Logic App to sync it with data lake cloud storage (there is a trigger which will detect changes in excel)

[Viren123]

Thanks Hubert. We were thinking if we can give input ready UI in the form of table instead of user creating files and uploading them. Is that something possible?

[prashant_kumar]

Hi Viren,

We are also looking for solution to a similar problem. what did you end up doing in this case?

[MikaelB]

Hi Viren, 

I have the same use case on my side and looking for some tips. I was thinking Power Apps and Power Automate with API calls for a job that will run the process but happy to check on other solutions as well !

Regards

[RajeevKum]

I achieved this using textbox widget and asked user to enter and run dashboard, in python code validating and inserting data in databricks.

2nd method , created excel vba application, using odbc connection to insert delete and update data in delta tables.