topic Re: Seeking Assistance with Dynamic %run Command Path in Get Started Discussions

Seeking Assistance with Dynamic %run Command Path

Lotfi — Thu, 21 Dec 2023 13:25:11 GMT

Hello Databricks Community Team,

I trust this message finds you well. I am currently facing an issue while attempting to utilize a dynamic path with the %run command to execute a notebook called from another folder. I have tested the following approaches using a conf_file variable:

%run "/Users/.../blob_conf/{}".format(conf_file)
%run f"/Users/.../blob_conf/{conf_file}"

Unfortunately, neither approach seems to be working as expected.

I would greatly appreciate your guidance and assistance in resolving this matter.

Thank you for your time and support.

Best regards,

Lotfi

Re: Seeking Assistance with Dynamic %run Command Path

chari — Thu, 21 Dec 2023 15:20:26 GMT

Hi,

If your config file is in the databricks file system then you should add dbfs:/

Ex: f"dbfs:/Users/.../blob_conf/{conf_file}"

Re: Seeking Assistance with Dynamic %run Command Path

Lotfi — Thu, 21 Dec 2023 16:29:26 GMT

Hello Chari,

I appreciate your response, but I'd like to clarify that I prefer not to utilize the filestore of DBK for storing my configuration file. Instead, I aim to directly execute the notebook that houses my Python configuration.
Furthermore, employing 'dbutils.notebook.run()' function doesn't enable me to access and utilize the declared variables within the notebook.
Thank youuu for any help.