I am using below code to create and read widgets. I am assigning default value.
dbutils.widgets.text("pname", "default","parameter_name")
pname=dbutils.widgets.get("pname")
I am using this widget parameter in some sql scripts. one example is given below
%sql
CREATE database if not exists ${pname}_test;
I am executing this notebook from an ADF. I am not passing any value to this parameter, so it will take default value.
Problem I am facing is, sometimes this widget value is reflecting and sometimes it is not reflecting in the sql script so it is creating "_test" database. This is happening in my dev environment. I am using exactly same code in my production environment, and there it is working fine.
Sometimes it is working all fine and sometimes I am facing this issue. Can anyone please help me to identify the issue?