Databricks Alerts Query result rows not being sent as a part of the email body

PTalathi
New Contributor

I am using a custom template in "Databricks Alerts" and an html code within it in order to trigger the query results within the body of the email. But unfortunately the email body contains the only the header specified in the html code and not the rows. Has anyone implemented such a scenario in Databricks alerts.