topic Re: User entry via portal/UI in Data Engineering

User entry via portal/UI

Viren123 — Mon, 30 Jan 2023 17:03:34 GMT

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

Re: User entry via portal/UI

Hubert-Dudek — Mon, 30 Jan 2023 17:52:13 GMT

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)

Re: User entry via portal/UI

Viren123 — Tue, 31 Jan 2023 12:45:37 GMT

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?

Re: User entry via portal/UI

prashant_kumar — Tue, 11 Jul 2023 03:36:18 GMT

Hi Viren,

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

Re: User entry via portal/UI

MikaelB — Thu, 12 Sep 2024 13:16:29 GMT

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

Re: User entry via portal/UI

RajeevKum — Mon, 24 Feb 2025 16:47:26 GMT

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.