https://community.databricks.com/t5/data-engineering/interactive-notebook-with-widgets/m-p/101305#M40624 <P>You can separate the user interface (UI) from the code logic by using two notebooks.</P> <P>1) The first notebook will contain the code that performs the actions based on the widget inputs.</P> <P>2)&nbsp;<SPAN>The second notebook will contain the widgets that users interact with.&nbsp;</SPAN><SPAN>Use <CODE>dbutils.widgets</CODE> to create the necessary widgets.&nbsp;Use the <CODE>%run</CODE> magic command to call the logic notebook, passing the widget values as parameters.</SPAN></P> <P><SPAN><A href="https://docs.databricks.com/en/notebooks/widgets.html#use-databricks-widgets-with-run" target="_blank">https://docs.databricks.com/en/notebooks/widgets.html#use-databricks-widgets-with-run</A></SPAN></P> <P>&nbsp;</P> Sat, 07 Dec 2024 05:45:46 GMT Mounika_Tarigop 2024-12-07T05:45:46Z https://community.databricks.com/t5/data-engineering/interactive-notebook-with-widgets/m-p/60307#M31631 <P>Dear experts,</P><P>We need to create a notebook in order the users to insert/update values in a specific table. We have created one using widgets. However the code performed per action selected is visible to the users. Is there a way to have in a the dropdown etc widgets in a notebook available to the users and the code relative to the actions to be in another one where they won't have access?</P><P>Thank you in advance!</P><P>&nbsp;</P> Thu, 15 Feb 2024 11:41:18 GMT https://community.databricks.com/t5/data-engineering/interactive-notebook-with-widgets/m-p/60307#M31631 elgeo 2024-02-15T11:41:18Z https://community.databricks.com/t5/data-engineering/interactive-notebook-with-widgets/m-p/101305#M40624 <P>You can separate the user interface (UI) from the code logic by using two notebooks.</P> <P>1) The first notebook will contain the code that performs the actions based on the widget inputs.</P> <P>2)&nbsp;<SPAN>The second notebook will contain the widgets that users interact with.&nbsp;</SPAN><SPAN>Use <CODE>dbutils.widgets</CODE> to create the necessary widgets.&nbsp;Use the <CODE>%run</CODE> magic command to call the logic notebook, passing the widget values as parameters.</SPAN></P> <P><SPAN><A href="https://docs.databricks.com/en/notebooks/widgets.html#use-databricks-widgets-with-run" target="_blank">https://docs.databricks.com/en/notebooks/widgets.html#use-databricks-widgets-with-run</A></SPAN></P> <P>&nbsp;</P> Sat, 07 Dec 2024 05:45:46 GMT https://community.databricks.com/t5/data-engineering/interactive-notebook-with-widgets/m-p/101305#M40624 Mounika_Tarigop 2024-12-07T05:45:46Z