Hi @AcrobaticMonkey,
How are you triggering the queries using a service principal, is it through a workflow job? If so then you can use Job notifications.
I would need more details but one possible solution is to implement Alerts:
https://docs.databricks.com/en/sql/user/alerts/index.html
