CODEWITHSUNDEEP
parameter-passingdropdowndatabricksdatabricks-sql
alphabetagamma
alphabetagamma

Reputation: 11

parameter in databricks sql analytics

I have a table like

name value1 value2
john a x
kevin b y
larry c z

I want to pass the parameter with dropdown values a,b,c,all where if user selects a then output is first row or if user selects all then also the out is all three rows. Please suggest.

Upvotes: 1

Views: 2787

Answers (2)

Alex Ott
Alex Ott

Reputation: 87184

You need to follow the documentation on creating the parameters for Databricks SQL. When editing the query, click on the {} icon to insert a new parameter into query, then select "Dropdown List" as a "Type", and enter possible values. Mark a checkbox "Allow multiple values" if you want to allow to select multiple values. And if you're using strings, timestamps, or dates, then select corresponding value from the "Quotation" dropdown:

enter image description here

and then modify your query to be something like (actions is the name of the parameter):

where action in ({{ actions }})

Then you can select necessary values from the dropdown:

enter image description here

and execution of the query should give you something like this:

enter image description here

Upvotes: 2

Utkarsh Pal
Utkarsh Pal

Reputation: 4544

Solution in PySpark:

Choise_List = map(lambda x: str(x[0]), <Dataframe_Name>.select("value1").distinct().collect()) 
dbutils.widgets.dropdown("a", "a", Choice_List)

Note: Change the <Dataframe_Name> with your actual dataframe name.

Upvotes: 0

Related Questions