topic Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template in Data Engineering

Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

merca — Thu, 16 Dec 2021 06:59:27 GMT

Please include in documentation an example how to incorporate the `QUERY_RESULT_ROWS` variable in the custom template.

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

jose_gonzalez — Thu, 06 Jan 2022 01:01:39 GMT

Hi @Merca Ovnerud ,

Here is the docs link https://docs.databricks.com/sql/user/alerts/index.html please let me know if this helps or you still have more follow questions.

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

realolap — Mon, 10 Jan 2022 07:58:07 GMT

Hi Jose,

I believe @Merca Ovnerud asked for the docs to include an example, but I cannot see that this has been added in the link you provided.

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

merca — Fri, 28 Jan 2022 08:01:50 GMT

@Jose Gonzalez Just sending me to documentations when I clearly state in my question that they are missing examples from the said documentation is borderline rude. And not responding even when someone tries to point this out, is even more.

Anyhow - could someone please tell me if there is possible (and how) to include data from the {{QUERY_RESULT_ROWS}} in the alert email?

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

merca — Fri, 28 Jan 2022 10:59:20 GMT

Hi @Kaniz Fatma ,

Thank you for the link. That was exactly what I was looking for. I hope this will be included in databricks documentation for others who may have the same problem!

Best

-Merca-

PS: Ask all the questions you like 😉

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

merca — Fri, 28 Jan 2022 12:47:20 GMT

Done!

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

Aleks — Mon, 12 Sep 2022 19:21:24 GMT

I was wondering about this same question, however, the link is no longer accessible. Could the example be included int he official databricks documentation?

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

merca — Tue, 13 Sep 2022 01:31:00 GMT

@Aleksandar Mirkovic I second that an example should be provided in documentation! (hint, hint @Kaniz Fatma 😉 )

Here is an example how to add the QUERY_RESULT_ROWS in email: (query result is table with 2 columns: column1,column2)

<table>
<tr><th>column1 header</th><th>column2 header</th></tr>
{{#QUERY_RESULT_ROWS}}
<tr>
<td>{{column1}}</td> <td>{{column2}}</td>
</tr>
{{/QUERY_RESULT_ROWS}}
</table>

note of caution: if a receiver have turned off html rendering in email, this does not look good!!! The tags will be written out as plain text

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

CJK053000 — Thu, 10 Oct 2024 17:48:46 GMT

@merca I have been using this same solution in alerts and it has been working great until yesterday, 10/9/2024. Now the results are showing up blank in my alert notification. Are you experiencing the same?

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

dec1mo — Fri, 18 Oct 2024 05:09:51 GMT

Hi @CJK053000, I'm experiencing the same behavior. Have you figured out the workaround?

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

abaghel — Fri, 18 Oct 2024 06:58:23 GMT

I am having the same issue as well from today. Any idea what is wrong and how to fix it ?

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

CJK053000 — Fri, 18 Oct 2024 15:03:07 GMT

I have a support ticket open and am awaiting feedback. I will report back once I have more info.

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

CJK053000 — Mon, 28 Oct 2024 15:11:57 GMT

Databricks confirmed this was an issue on their end and it should be resolved now. It is working for me.

Re: Value array {{QUERY_RESULT_ROWS}} in Databricks SQL alerts custom template

gayatrikhatale — Mon, 01 Sep 2025 10:22:52 GMT

Hi @merca ,
This is not working for me. Can you please help me with this ?

Thank you.