https://community.databricks.com/t5/machine-learning/pass-parameter-from-python-to-sql-null-result/m-p/22097#M1255 <P>Hello. Could someone please explain at the below example, why having the prefix "da" at the parameter name allows us to select the parameter value but not having it returns to a null value?</P><P></P><P>Correct value</P><P><span class="lia-inline-image-display-wrapper" image-alt="UDF_OK"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1176iA0B6B2308390C09C/image-size/large?v=v2&amp;px=999" role="button" title="UDF_OK" alt="UDF_OK" /></span>Null value</P><P>&nbsp;<span class="lia-inline-image-display-wrapper" image-alt="UDF_NOT_OK"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1189i60AF4BB6F118C2DA/image-size/large?v=v2&amp;px=999" role="button" title="UDF_NOT_OK" alt="UDF_NOT_OK" /></span>Thank you in advance</P> Wed, 16 Nov 2022 09:30:05 GMT elgeo 2022-11-16T09:30:05Z https://community.databricks.com/t5/machine-learning/pass-parameter-from-python-to-sql-null-result/m-p/22097#M1255 <P>Hello. Could someone please explain at the below example, why having the prefix "da" at the parameter name allows us to select the parameter value but not having it returns to a null value?</P><P></P><P>Correct value</P><P><span class="lia-inline-image-display-wrapper" image-alt="UDF_OK"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1176iA0B6B2308390C09C/image-size/large?v=v2&amp;px=999" role="button" title="UDF_OK" alt="UDF_OK" /></span>Null value</P><P>&nbsp;<span class="lia-inline-image-display-wrapper" image-alt="UDF_NOT_OK"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1189i60AF4BB6F118C2DA/image-size/large?v=v2&amp;px=999" role="button" title="UDF_NOT_OK" alt="UDF_NOT_OK" /></span>Thank you in advance</P> Wed, 16 Nov 2022 09:30:05 GMT https://community.databricks.com/t5/machine-learning/pass-parameter-from-python-to-sql-null-result/m-p/22097#M1255 elgeo 2022-11-16T09:30:05Z https://community.databricks.com/t5/machine-learning/pass-parameter-from-python-to-sql-null-result/m-p/22098#M1256 <P>Any insight on this? Thank you!</P> Tue, 22 Nov 2022 07:59:03 GMT https://community.databricks.com/t5/machine-learning/pass-parameter-from-python-to-sql-null-result/m-p/22098#M1256 elgeo 2022-11-22T07:59:03Z