Create variable for insert or change data lake folder path in Databricks

Viewed 79

Im new with Databricks so thats why i am asking you for any advices.

Current situation: In DEV environment we used hardcoded folder location of data lake folder in development. When release this to Acceptance environment we need to manually changes als the hardcoded values in the notebook.

As you can see here we inserted the hardcoded value of the folder.

  • storage account name = sadwhpostge001
  • container name= excel folder
  • name = bronze

In Acceptance environment the only difference from the Development is the storage account name.

How can we create parameters and insert the right values when the notebook is deployed in Acceptance? i am thinking using Widget but do not have any best practices.

Any suggestions? Many thanks.

enter image description here

0 Answers
Related