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

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 | Microsoft Fabric

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