topic Re: How to pass dynamic value in databricks in Data Engineering

How to pass dynamic value in databricks

Siddhesh2525 — Wed, 01 Dec 2021 11:16:56 GMT

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 .

Re: How to pass dynamic value in databricks

Hubert-Dudek — Wed, 01 Dec 2021 11:32:14 GMT

Hi you can run one notebook from another and pass value as widget:

run_notebook(notebook, timeout, widgets_value)

Here is more info https://docs.databricks.com/notebooks/notebook-workflows.html

You can even run them in many processes simultaneously:

    from multiprocessing.pool import ThreadPool
    my_params =  ["Eu","JP","APAC"]
    pool = ThreadPool(4) # match cpu cores here
    pool.map(
        lambda my_param: run_notebook("my_notebook", 3600, {"my_widget": my_param}),
        my_params)

Re: How to pass dynamic value in databricks

Prabakar — Thu, 02 Dec 2021 15:06:37 GMT

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"