How to create alerts for query execution in data warehouse? Warehouse doesn't appear in the source

[Subashri_Vasu]

I understand that, running a pipeline, notebook, dataflow or a SQL query in warehouse creates a job. But in order to monitor the SQL job, I need to choose it as a source in the alert. But I am not able to choose warehouse\ sql as source. Can you tell if this is possible in the first place? If possible, please guide me on how do we do it? 

[v-dineshya · Accepted solution]

Hi @Subashri_Vasu ,

Thank you for reaching out to the Microsoft Community Forum.

It is possible to Create Alerts for SQL Query Execution in Microsoft Fabric Warehouse, but not directly through the traditional alerting interface using "Warehouse" as a source. Microsoft Fabric provides alternative mechanisms for monitoring SQL query execution:

1. Fabric Data Warehouse includes a built-in Query Store that automatically collects and stores up to 30 days of query and execution history. It also auto-generates insights into workloads for performance tuning and monitoring.

Note: You can analyze query performance and execution patterns. And can use this data to build dashboards or trigger alerts indirectly.

2. Microsoft Fabric’s Data Activator allows you to set up alerts based on data conditions. It doesn’t directly support SQL job sources, you can stream query metrics or job logs into a KQL database via Eventstream. Use KQL queries to define alert conditions . Set alerts using the “Set an alert” option in the query editor.

3. You can visualize query execution metrics in Power BI and use Data Activator to trigger alerts when thresholds are breached.

Please refer below steps to set up Alerts for SQL Query Execution.

1. Go to your Fabric Warehouse and access the Query Store and Export query metrics (duration, execution count). Build a Power BI report using this data. Use Data Activator to monitor the report and trigger alerts.

2. Create an Eventhouse and Eventstream to capture SQL job metrics. Stream data into a KQL database. Write a KQL query to detect anomalies. Use the “Set an alert” option in the query editor to define alert logic.

Please refer Microsoft official documents and Microsoft Blogs for your reference.

Set alerts on Fabric workspace item events in Real-Time hub - Microsoft Fabric | Microsoft Learn

Introduction to Activator - Microsoft Fabric | Microsoft Learn

Driving actions from your data with Data Activator  | Microsoft Fabric Blog | Microsoft Fabric

Set Data Activator alerts on KQL Querysets | Microsoft Fabric Blog | Microsoft Fabric

Implementing proactive monitoring with KQL query alerts with Activator | Microsoft Fabric Blog | Mic...

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.

Regards,

Dinesh

[v-dineshya]

Hi @Subashri_Vasu ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[v-dineshya]

Hi @Subashri_Vasu ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Thank you.

[v-dineshya]

Hi @Subashri_Vasu ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Thank you.