12-15-2021 10:59 PM
Please include in documentation an example how to incorporate the `QUERY_RESULT_ROWS` variable in the custom template.
12-15-2021 11:07 PM
Hi @ merca! My name is Kaniz, and I'm the technical moderator here. Great to meet you, and thanks for your post. Sure, I shall inform the doc team. Thanks!
01-05-2022 05:01 PM
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.
01-09-2022 11:58 PM
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.
01-28-2022 12:47 AM
Hi @Ola Pukstad , Thanks for your concern. We'll try to include the example requested by @Merca Ovnerud in the documentation as soon as possible. Thanks for flagging it @Merca Ovnerud .
01-28-2022 12:01 AM
@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?
01-28-2022 12:40 AM
Hi @Merca Ovnerud , I completely understand the frustration you’re feeling. I’m sure I’d feel the same way. Can I ask you a few questions so we can get this resolved?
01-28-2022 12:49 AM
Here is the link which may answer your question related to {{QUERY_RESULT_ROWS}} -
Please feel free to reach out in case you've more questions about it. We're here to help you 😊 .
01-28-2022 02:59 AM
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 😉
01-28-2022 03:14 AM
Hi @Merca Ovnerud , So happy to help you!
Would you like to mark it as the best answer?
01-28-2022 04:47 AM
Done!
09-12-2022 12:21 PM
I was wondering about this same question, however, the link is no longer accessible. Could the example be included int he official databricks documentation?
09-12-2022 06:31 PM
@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
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group