- 12294 Views
- 8 replies
- 6 kudos
Databricks notebook ipywidgets not working as expected ( button click issue)
I am working on Azure databricks(IDE). I wanted to create a button which takes a text value as input and on the click of a button a function needed to be run which prints the value entered.For that I created this code:from IPython.display import disp...
- 12294 Views
- 8 replies
- 6 kudos
- 6 kudos
Hi @Shubham Ringne​ Hope everything is going great.Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us s...
- 6 kudos
- 2565 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...
- 2565 Views
- 3 replies
- 3 kudos
- 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
- 1878 Views
- 2 replies
- 0 kudos
Unable to render widget to display map within Jupyter notebook output cell
I am attempting to render a map within jupyter notebook and keep bumping into output limit. Below is my code: import pydeck as pdk import pandas as pd COLOR_BREWER_BLUE_SCALE = [ [240, 249, 232], [204, 235, 197], [168, 221, 181], ...
- 1878 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @Keval Shah​ Thank you for your question! To assist you better, please take a moment to review the answer and let me know if it best fits your needs.Please help us select the best solution by clicking on "Select As Best" if it does.Your feedback w...
- 0 kudos
- 5860 Views
- 3 replies
- 5 kudos
Notebook dropdown widget
I have created a dropdown (say B) in my notebook whose input depend on dropdown( say B). So if select some value in dropdown A, it corresponding value appears in B dropdown & i'm selecting one amongst it. Now if i change the value in dropdown A, then...
- 5860 Views
- 3 replies
- 5 kudos
- 5 kudos
If the previously selected value of B is not meant to be in the list of values for newly selected dropdown A value, then you could set a default value (ie: 'No selection') that the B dropdown should have when first created. In a method to define how ...
- 5 kudos
- 1077 Views
- 2 replies
- 0 kudos
adding Widget as a column and populating its value every-time in that column in a table.
hi , I want date for runtime from ADF as @utcnow() -- base paramater of notebook activity in ADF and take the data in ADB using widgets as runtime_date, further i want that column to be added in my table X with the populated value from the widget.Eve...
- 1077 Views
- 2 replies
- 0 kudos
- 0 kudos
you can use as current_timestamp() or now()refer link: https://docs.databricks.com/sql/language-manual/functions/current_timestamp.html
- 0 kudos
- 1661 Views
- 1 replies
- 4 kudos
Resolved! Accept widget value during runtime from user
list1 = ('alpha', 'beta', 'gamma', 'eta', 'Theta')list2 = ('alpha', 'beta')df1 = spark.createDataFrame(list1, 'String').withColumnRenamed('value', 'dataset')df2 = spark.createDataFrame(list2, 'String').withColumnRenamed('value', 'dataset')df = df1.ex...
- 1661 Views
- 1 replies
- 4 kudos
- 4 kudos
Every time the user change selection in the widget, you get that selection—behavior after the dropdown change you can define in widget settings.
- 4 kudos
- 1843 Views
- 2 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, ...
- 1843 Views
- 2 replies
- 1 kudos
- 1 kudos
Hi @Reza Rajabi​ this is a known thing and we have a feature request to fix this. I do not have an ETA on when this feature will be available. So for now to avoid the widgets being in alphabetical order, you need to use the prefix like 1,2,3.. or A,B...
- 1 kudos
- 8447 Views
- 8 replies
- 12 kudos
Resolved! How to programmatically create a widget?
I know the dbutils.widget.text to create a widget in a notebook. So for me the workflow 1. Having a notebook2. Use dbutils.widget.text (or other type of widgets) once in a notebook cell to create a widget3. Remove the cell containing dbutils.widget...
- 8447 Views
- 8 replies
- 12 kudos
- 12 kudos
@Mehdi BEN ABDESSELEM​ , Steps for Creating a Basic WidgetStep 1: Create a New ProjectTo create a new project in Android Studio, please refer to How to Create/Start a New Project in Android Studio. We are implementing it for both Java and Kotlin lang...
- 12 kudos
- 9298 Views
- 8 replies
- 1 kudos
Resolved! Notebook's Widget parameters in SQL cell => howto
dbutils.widgets.text('table', 'product') %sql select * from ds_data.$tableHello, the above will work.But how can I do something like:dbutils.widgets.text('table', 'product') %sql select * from ds_data.$table_v3in that example, $table is still my ...
- 9298 Views
- 8 replies
- 1 kudos
- 6092 Views
- 2 replies
- 2 kudos
Resolved! current date as default in a widget while scheduling the notebook
I have a scheduled a notebook. can I keep current date as default in widget whenever the notebook run and also i need the flexibility to change the widget value to any other date based on the ad hoc run that I do.
- 6092 Views
- 2 replies
- 2 kudos
- 2 kudos
So building on the answer of Hubert:from datetime import datedate_for_widget = date.today()So if you use date_for_widget as your default value, you are there.And ofc you can fill this date_for_widget variable with anything you want.You can even fetch...
- 2 kudos
- 9723 Views
- 3 replies
- 3 kudos
Resolved! Why doesn't my notebook display widgets when I use 'dbutils' while it is displayed with '%sql CREATE WIDGET'?
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", "oran...
- 9723 Views
- 3 replies
- 3 kudos
- 3 kudos
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!:)
- 3 kudos
- 5295 Views
- 1 replies
- 4 kudos
- 5295 Views
- 1 replies
- 4 kudos
- 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
- 6982 Views
- 3 replies
- 0 kudos
Resolved! How to see the textbox input from getArgument() or dbutils.widgets.text() or dbutils.widgets.dropdown()
getArgument() has been deprecated. I don't see the text box for me to type in any input anymore. What I actually see though is the following error: Deprecation warning: Use dbutils.widgets.text() or dbutils.widgets.dropdown() to create a widget and...
- 6982 Views
- 3 replies
- 0 kudos
- 0 kudos
So shouldn't it be removed from the tutorial notebook showing how to connect to S3? I'm trying to connect to S3 for the first time and a deprecation warning isn't a pleasant first experience with a tool I am paying for.
- 0 kudos