Cannot Get Query Results in SQL Alerts

AcrobaticMonkey — Wed, 30 Oct 2024 05:25:37 GMT

Example Query:

select name, date from errors;

Now i want to trigger an alert if count is greater than 1, and a notification should be sent to slack with output rows (name and date values). Even if i use {{QUERY_RESULT_ROWS}}, it only gives value after count is applied.

Is there any way to get the actual rows using Alerts?

Re: Cannot Get Query Results in SQL Alerts

VZLA — Thu, 31 Oct 2024 16:34:58 GMT

Note I have not tried this myself, but can you try the following and let me know if it helps:

Create the query, so SELECT name, date FROM errors;
Set up the alert. Set the condition to trigger the alert when the count of rows is greater than 1.
Create a separate query that formats the result as a single string.
1. SELECT CONCAT_WS(', ', COLLECT_LIST(CONCAT(name, ' - ', date))) AS formatted_result FROM errors WHERE <your_condition>;
2. Use this query in your alert to trigger the notification. The formatted_result should contain the concatenated rows.
Send notification to Slack. In the alert settings, you can use the formatted_result to include the actual rows in the message.

topic Cannot Get Query Results in SQL Alerts in Data Engineering

Cannot Get Query Results in SQL Alerts

Re: Cannot Get Query Results in SQL Alerts