cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

fijoy
by Contributor
  • 10982 Views
  • 6 replies
  • 10 kudos

How to remove widgets from a notebook dashboard?

I'm creating a dashboard from the output of a notebook cell, but noticing that the dashboard displays the the widgets of the notebook in addition to the cell output. How can I remove the widgets from the dashboard?

  • 10982 Views
  • 6 replies
  • 10 kudos
Latest Reply
Nico2
New Contributor II
  • 10 kudos

Did you find any solution for this? I am facing a similar issue wanting to create multiple dashboads on a single notebook where not all widgets are relevant for both dashboards. this makes it difficult for users to understand the dahsboard.

  • 10 kudos
5 More Replies
andresfp14
by New Contributor II
  • 26252 Views
  • 2 replies
  • 0 kudos

Can you delete a widget, or force a value to it?

Hello everyone! Basically, I have a dropdown widget, and at some point I want to change the options available, but still maintain the same selected option. The problems that I find are: - If I want to delete the widget and create a new one, it seems...

0693f000007OoHmAAK
  • 26252 Views
  • 2 replies
  • 0 kudos
Latest Reply
Gim
Contributor
  • 0 kudos

I know this is 5+ years late but I would like to add an answer (or work around) to this in case anyone else was looking for the same solution.What I did was to essentially 'reset' the widget whenever I had to assign (or force) a value to it.#Cell #1 ...

  • 0 kudos
1 More Replies
tessaickx
by New Contributor III
  • 2006 Views
  • 3 replies
  • 3 kudos

Using ipywidgets latest versions

Hello everyone,I upgraded my cluster to DBR 13.0, which comes with ipywidgets version 7.7.2 installed.However, I want to use the TagsInput widget, which is new since version 8.0.4.If i upgrade the ipywidgets package to version 8.0.4, none of the widg...

  • 2006 Views
  • 3 replies
  • 3 kudos
Latest Reply
Anonymous
Not applicable
  • 3 kudos

Hi @Tessa Ickx​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers yo...

  • 3 kudos
2 More Replies
MShee
by New Contributor II
  • 1129 Views
  • 1 replies
  • 1 kudos
  • 1129 Views
  • 1 replies
  • 1 kudos
Latest Reply
NandiniN
Honored Contributor
  • 1 kudos

Hello @M Shee​ ,In a drop down you can select a value from a list of provided values, not type the values in. What you might be interested in is a combobox - It is combination of text and dropdown. It allows to select a value from a provided list or ...

  • 1 kudos
farbodr
by New Contributor II
  • 3173 Views
  • 4 replies
  • 1 kudos

Shapley Progressbar

The shapley progress bar or tqdm progress bar in general doesn't show in notebooks. Do I need to set something special to get this or any other similar widgets to work?

  • 3173 Views
  • 4 replies
  • 1 kudos
Latest Reply
Anonymous
Not applicable
  • 1 kudos

Hi @Fred Rahmanian​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Tha...

  • 1 kudos
3 More Replies
Deiry
by New Contributor III
  • 768 Views
  • 0 replies
  • 0 kudos

Why is the whole list not displayed in dbutil.widgets.multiselect?

I have been studying the Apache Spark in Databricks Academy and I don't understand why the whole list is nos displayed? Creation of widgets:dbutils.widgets.text("name", "Brickster", "Name") dbutils.widgets.multiselect("colors","orange", ["orange", "r...

image
  • 768 Views
  • 0 replies
  • 0 kudos
g96g
by New Contributor III
  • 4044 Views
  • 2 replies
  • 1 kudos

Resolved! how can I pass the df columns as a parameter

Im doing the self study and want pass df column name as a parameter.I have defined the widget column_name= dbutils.widgets.get('column_name')which is executing succefuly ( giving me a column name)then Im reading the df and do some transformation and ...

  • 4044 Views
  • 2 replies
  • 1 kudos
Latest Reply
Kaniz_Fatma
Community Manager
  • 1 kudos

Hi @Givi Salu​ , We haven’t heard from you since the last response from @Hubert Dudek​, and I was checking back to see if you have a resolution yet. If you have any solution, please share it with the community as it can be helpful to others. Otherwis...

  • 1 kudos
1 More Replies
dimsh
by Contributor
  • 10194 Views
  • 13 replies
  • 11 kudos

Resolved! How to overcome missing query parameters in Databricks SQL?

Hi, there! I'm trying to build up my first dashboard based on Dataabricks SQL. As far as I can see if you define a query parameter you can't skip it further. I'm looking for any option where I can make my parameter optional. For instance, I have a ta...

  • 10194 Views
  • 13 replies
  • 11 kudos
Latest Reply
DavePete_79593
New Contributor II
  • 11 kudos

And I can't submit a feature request because when I select feedback I get: HTTP ERROR 403Problem accessing /sso/ideas. Reason: Invalid or missing CSRF token

  • 11 kudos
12 More Replies
Reza
by New Contributor III
  • 1493 Views
  • 3 replies
  • 1 kudos

Can we order the widgets in Databricks?

I am trying to order the way that widgets are shown in Databricks, but I cannot. For example, I have two text widgets (start date and end date). Databricks shows "end_date" before "start_date" on top, as the default order is alphabetical. Obviously, ...

  • 1493 Views
  • 3 replies
  • 1 kudos
Latest Reply
Kaniz_Fatma
Community Manager
  • 1 kudos

Hi @Reza Rajabi​ , We haven’t heard from you on the last response from @Prabakar Ammeappin​ , and I was checking back to see if his suggestions helped you. Or else, If you have any solution, please do share that with the community as it can be helpfu...

  • 1 kudos
2 More Replies
entimaniac
by New Contributor
  • 8473 Views
  • 1 replies
  • 0 kudos

How to catch exception from dbutils.widgets.get(...)

I'm trying to write python notebook code that can be run from databricks web ui or from airflow. I intend to pass parameters from airflow via the job api using notebook_params. From what I understand, these are accessible as widget values. dbutils....

  • 8473 Views
  • 1 replies
  • 0 kudos
Latest Reply
blt
New Contributor II
  • 0 kudos

I handle this exception with something like:import py4j try: value = dbutils.widgets.get("parameter") except py4j.protocol.Py4JJavaError as e: print(e)If you look more closely at the stack trace you'll see the origin of the message is from some...

  • 0 kudos
Reza
by New Contributor III
  • 5077 Views
  • 8 replies
  • 8 kudos

Datepicker widget

There are textbox and dropdown list widgets in Databricks. Is there any datepicker widget? If not, is there any plan to add it?

  • 5077 Views
  • 8 replies
  • 8 kudos
Latest Reply
Kaniz_Fatma
Community Manager
  • 8 kudos

Hi @Reza Rajabi​ , Just a friendly follow-up. Do you still need help, or does my response help you to find the solution? Please let us know.

  • 8 kudos
7 More Replies
shan_chandra
by Esteemed Contributor
  • 4284 Views
  • 2 replies
  • 4 kudos
  • 4284 Views
  • 2 replies
  • 4 kudos
Latest Reply
shan_chandra
Esteemed Contributor
  • 4 kudos

Please refer to the below widget example using SQL %sql DROP VIEW IF EXISTS tempTable; CREATE temporary view tempTable AS SELECT 'APPLE' as a UNION ALL SELECT 'ORANGE' as a UNION ALL SELECT 'BANANA' as a; CREATE WIDGET DROPDOWN fruits DEFAULT 'ORAN...

  • 4 kudos
1 More Replies
laus
by New Contributor III
  • 5716 Views
  • 5 replies
  • 6 kudos

Resolved! How to sort widgets in a specific order?

I'd like to have a couple of widgets, one for the start and another for end date. I want them to appear in that order but when I run the code below, end date shows up before the start date. How can order in the way I I desired?dbutils.widgets.text("s...

  • 5716 Views
  • 5 replies
  • 6 kudos
Latest Reply
laus
New Contributor III
  • 6 kudos

@Ravirahul Padmanabhan​  and @Werner Stinckens​ , for me going into edit mode as suggested by Ravi worked like a charm! Thank you both!

  • 6 kudos
4 More Replies
Reza
by New Contributor III
  • 2471 Views
  • 2 replies
  • 0 kudos

Resolved! Can we order the widgets?

I have two text widgets (dbutils.widgets.text). One is called "start date" and another one is "end date". When I create them, they will be shown in alphabetic order (end_date, start_date). Is there any way that we can set the order when we create the...

  • 2471 Views
  • 2 replies
  • 0 kudos
Latest Reply
Atanu
Esteemed Contributor
  • 0 kudos

https://docs.databricks.com/notebooks/widgets.html all options available here I think. @Reza Rajabi​  , but we can crosscheck

  • 0 kudos
1 More Replies
Siddhesh2525
by New Contributor III
  • 4918 Views
  • 2 replies
  • 6 kudos

How to pass dynamic value in databricks

I have separate column value defined in 13 diffrent notebook and i want merge into 1 databrick notebook and want to pass dynamic parameter using databrick so it will help me to run in single databricks notebook .

  • 4918 Views
  • 2 replies
  • 6 kudos
Latest Reply
Prabakar
Esteemed Contributor III
  • 6 kudos

Hi @siddhesh Bhavar​ you can use widgets with the %run command to achieve this. https://docs.databricks.com/notebooks/widgets.html#use-widgets-with-run%run /path/to/notebook $X="10" $Y="1"

  • 6 kudos
1 More Replies
Labels