topic Re: Pass parameter value to sql query in databricks sql alert in Get Started Discussions

Pass parameter value to sql query in databricks sql alert

gayatrikhatale — Fri, 29 Aug 2025 11:35:28 GMT

Hi,
I have created a sql query with the parameter.
Now using that parameterized sql query in databricks legacy sql alert.
And scheduling that databricks sql alert in databricks workflow/job using Sql task type.
Now how should I pass the parameter value to sql query. Because I want to send that parameter value in runtime.

Re: Pass parameter value to sql query in databricks sql alert

Khaja_Zaffer — Mon, 01 Sep 2025 23:08:19 GMT

Hello @gayatrikhatale

Good day!!

You can use like this

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

Re: Pass parameter value to sql query in databricks sql alert

Khaja_Zaffer — Mon, 01 Sep 2025 23:36:14 GMT

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

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

Re: Pass parameter value to sql query in databricks sql alert

gayatrikhatale — Tue, 02 Sep 2025 04:43:30 GMT

Thanks for the clarification.

Re: Pass parameter value to sql query in databricks sql alert

Khaja_Zaffer — Tue, 02 Sep 2025 06:39:15 GMT

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.

Re: Pass parameter value to sql query in databricks sql alert

gayatrikhatale — Wed, 10 Sep 2025 06:51:38 GMT

Hi @Khaja_Zaffer ,

My issue is resolved. I am using SQL Query API to parameterize sql query and assign a new value every time. And then using that SQL query in the alert.

Thank you!

Re: Pass parameter value to sql query in databricks sql alert

Khaja_Zaffer — Wed, 10 Sep 2025 08:43:39 GMT

Okay thank you @gayatrikhatale

Good to know that.