cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Bug with Azure Databricks SQL query parameters

Wilson
New Contributor

2 Issues both related to query based drop down please read below documentation for more info:

https://docs.microsoft.com/en-us/azure/databricks/sql/user/queries/query-parameters#query-based-drop...

Issue # 1

Drop down list only accepts up to 400 values

Only affects parameters which are a name/value pair

After 400 values, the drop-down box glitches out, displays duplicate values and user is unable to scroll

Issue # 2

Query based dropdown selects multiple values when user only selects 1

Only affects parameters which are a name/value pair

If the value is not unique to the name (see example), when user selects the parameter multiple other names are also selected as a multi-select, even when user only wants to select 1

Attached repro steps and screenshots.

Please reach out if you need more info

1 ACCEPTED SOLUTION

Accepted Solutions

Prabakar
Databricks Employee
Databricks Employee

Hi @Wilson Leeโ€‹ Thanks for the information. We'll test this internally and discuss it with the product team to fix it.

View solution in original post

1 REPLY 1

Prabakar
Databricks Employee
Databricks Employee

Hi @Wilson Leeโ€‹ Thanks for the information. We'll test this internally and discuss it with the product team to fix it.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group