Akhil Mahajan

Using widgets in SQL notebooks in  Azure Databricks In this article we will see how data engineers/data analysts using SQL Notebooks in Azure Databricks can use widgets to parameterize their notebooks. Adding parameters to the queries make the queries dynamic, helping users to use the same query to drive results as per their needs. The support of parameters in Azure Databricks is offered via widgets .  Input widgets allow users to add parameters to their notebooks and dashboards. The widget API consists of calls to create various types of input widgets, remove them, and get bound values. Widgets are best for: Building a notebook or dashboard that is re-executed with different parameters Quickly exploring results of a single query with different parameters Currently there are 4 types of widgets — text : accepts string characters dropdown : provides a list of values combobox : provides a combination of string characters and dropdown. Basically, you have the option to either choose from