topic Re: Dropdown for parameters in a job in Data Engineering

Dropdown for parameters in a job

cmilligan — Fri, 11 Nov 2022 17:09:24 GMT

I want to be able to denote the type of run from a predetermined list of values that a user can choose from when kicking off a run using different parameters. Our team does standardized job runs on a weekly cadence but can have timeframes that changed depending on the month or if it is a one off run to test. I am wanting to change the behavior of the run depending on the type of run it is and want to have users choose from a list to reduce errors like misspellings. Is there a good option to do this inside of the job itself, rather than a notebook?

Re: Dropdown for parameters in a job

UmaMahesh1 — Sat, 03 Dec 2022 10:30:44 GMT

Hi @Coleman Milligan

Checking the old unanswered questions and stumbled across this.

You can do that using the databricks widgets.

dbutils.widgets.dropdown("state", "CA", ["CA", "IL", "MI", "NY", "OR", "VA"])

If this widget is not helping you in passing parameters, you can do a try catch in all the notebooks to check if the parameter value you are passing is actually in the list of strings you have.

Hope this helps.

Cheers.

Re: Dropdown for parameters in a job

cmilligan — Wed, 07 Dec 2022 17:31:59 GMT

Hi @Uma Maheswara Rao Desula , thank you for the reply.

I'm actually wondering if there is a way to do this within the job ui using the 'run with different parameters' functionality.

It would be the environment key that I'm wanting to restrict user inputs into a predetermined list.

Re: Dropdown for parameters in a job

dev56 — Fri, 05 Apr 2024 11:04:27 GMT

Hi @cmilligan , I have a similar requirement and would really be grateful if you could provide me with any information on how to fix this issue. Thanks a lot!

Re: Dropdown for parameters in a job

Leon_K — Wed, 11 Dec 2024 18:23:42 GMT

I'm looking to this too. Wonder if there a way to make as a drop down for a job parameter