topic QUERY_RESULT_ROWS without first row as trigger in SQL Alerts of databricks in Data Engineering

QUERY_RESULT_ROWS without first row as trigger in SQL Alerts of databricks

rajalakshmi9394 — Fri, 17 Feb 2023 12:47:28 GMT

Hi Team - In azure databricks sql alerts, I was able to use QUERY_RESULT_ROWS only if I'm selecting the trigger as first row. Is there a possibility to get count of number of rows and also the query result (both rows and columns to display the data as table) inside the custom alert notification template of sql in databricks

Re: QUERY_RESULT_ROWS without first row as trigger in SQL Alerts of databricks

-werners- — Fri, 17 Feb 2023 13:46:06 GMT

I also looked into that and for the moment it does not seem to be possible.

I worked around this by triggering on the count of records of the concerning query and also including the url to the query.

Like that the receiver can click on the link and run the query.

But I would very much like to be able to include the actual results (even only the first 100 rows).

Re: QUERY_RESULT_ROWS without first row as trigger in SQL Alerts of databricks

Anonymous — Sat, 18 Feb 2023 06:53:27 GMT

Hi @Rajalakshmi Amara

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you.

Cheers!

Re: QUERY_RESULT_ROWS without first row as trigger in SQL Alerts of databricks

jose_gonzalez — Thu, 23 Feb 2023 18:15:21 GMT

Hi @Rajalakshmi Amara ,

Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.