QUERY_RESULT_ROWS without first row as trigger in SQL Alerts of databricks

rajalakshmi9394
New Contributor II

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