queryinsights.exec_requests_history (Transact-SQL)
Applies to: 
SQL analytics endpoint and Warehouse in Microsoft Fabric
The queryinsights.exec_requests_history in Microsoft Fabric provides information about each completed SQL request.
| Column name | Data type | Description |
|---|---|---|
distributed_statement_id |
uniqueidentifier | Unique ID for each query. |
start_time |
datetime2 | Time when the query started running. |
command |
varchar(8000) | Complete text of the executed query. |
login_name |
varchar(128) | Name of the user or system that sent the query. |
row_count |
bigint | Number of rows retrieved by the query. |
total_elapsed_time_ms |
int | Total time (ms) taken by the query to finish. |
status |
varchar(30) | Query status: Succeeded, Failed, or Cancelled |
session_id |
smallint | ID linking the query to a specific user session. |
connection_id |
uniqueidentifier | Identification number for the query's connection. Nullable. |
batch_id |
uniqueidentifier | ID for grouped queries (if applicable). Nullable. |
root_batch_id |
uniqueidentifier | ID for the main group of queries (if nested). Nullable. |
query_hash |
varchar(200) | Binary hash value calculated on the query and used to identify queries with similar logic. You can use the query hash to correlate between Query Insight views. For more information, see Query Insights - Aggregation. |
label |
varchar(8000) | Optional label string associated with some SELECT query statements. |
Permissions
You should have access to a SQL analytics endpoint or Warehouse within a Premium capacity workspace with Contributor or above permissions.