Hello @gayatrikhatale 

Good day!!

You can use like this 

Just to understand, did you save the alert with the threshold value?

I understand your issue but here: https://learn.microsoft.com/en-us/azure/databricks/jobs/sql#:~:text=Alerts%20do%20not%20support%20pa.... according to documentation it says not supported. 

if you want to do it dynamically enter a value, its complicated. 

Thanks for the clarification.

Hello @gayatrikhatale 

If you are okay, can you please share what you are trying to parameterize in the sql query. If you share in detail I think we can work out. 
If you already got a solution let me know. 

Thank you. 

Okay thank you @gayatrikhatale 

Good to know that.