topic Re: Why doesn't my notebook display widgets when I use 'dbutils' while it is displayed with '%sql CREATE WIDGET'? in Data Engineering

Why doesn't my notebook display widgets when I use 'dbutils' while it is displayed with '%sql CREATE WIDGET'?

daindana — Thu, 30 Sep 2021 05:20:17 GMT

The widget is not shown when I use dbutils while it works perfect with sql.

For example,

%sql
 
CREATE WIDGET TEXT state DEFAULT "CA"

This one shows me widget.

dbutils.widgets.text("name", "Brickster", "Name")
dbutils.widgets.multiselect("colors", "orange", ["red", "orange", "black", "blue"], "Traffic Sources")

This one shows nothing even though I can see `Command took 0.03 seconds` message.

Also, I can get results from widget even though I cannot see it when I use codes below.

name = dbutils.widgets.get("name")
colors = dbutils.widgets.get("colors").split(",")
 
html = "<div>Hi {}! Select your color preference.</div>".format(name)
for c in colors:
  html += """<label for="{}" style="color:{}"><input type="radio"> {}</label><br>""".format(c, c, c)
 
displayHTML(html)

I attached images.

Re: Why doesn't my notebook display widgets when I use 'dbutils' while it is displayed with '%sql CREATE WIDGET'?

Ryan_Chynoweth — Mon, 11 Oct 2021 20:30:23 GMT

Hi @DAIN KIM , I tried to reproduce your issue but was unable to. Which language of notebook are you using (python,sql)?

And just to be clear, the python dbutils.widget.text does not show up at the top of the notebook?

Re: Why doesn't my notebook display widgets when I use 'dbutils' while it is displayed with '%sql CREATE WIDGET'?

daindana — Mon, 11 Oct 2021 23:45:54 GMT

Hello, Ryan! For some reason, this problem is solved, and now it is working perfectly! I did nothing new, but it is just working now.

Thank you!:)

Re: Why doesn't my notebook display widgets when I use 'dbutils' while it is displayed with '%sql CREATE WIDGET'?

Ryan_Chynoweth — Tue, 12 Oct 2021 16:25:19 GMT

That is great to hear! It seemed like an odd issue but glad it all worked out.