Forum Discussion
Lakehouse SQL analytics endpoint logs
Does the Lakehouse SQL analytics endpoint provide logging capabilities? I need to verify the number of rows queried from a specific SQL endpoint within a defined time frame. We are encountering a discrepancy between the number of records present in the lakehouse table and the count retrieved by a third-party tool accessing data through the SQL analytics endpoint.
Hi lissethlopezl ,
Thank you for reaching out to the Microsoft fabric community forum.
Currently, the Lakehouse SQL Analytics Endpoint in Microsoft Fabric does not offer native logging capabilities to track the number of rows queried or detailed query execution history.
To address your need to verify how many rows were accessed via the SQL endpoint within a specific timeframe, you can consider enabling SQL audit logs (preview) in Fabric, which capture query activity, user access, and execution timestamps, though not row-level detail.
You can refer to the official documentation here: https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-audit-logs
Additionally, to validate the row count retrieved by a third-party tool, we recommend manually executing a SELECT COUNT(*) query with matching filters. If there’s a chance the SQL endpoint is not reflecting recent data due to metadata lag, you can use the Refresh SQL Analytics Endpoint Metadata API, which helps ensure the SQL endpoint is in sync with lakehouse updates. Also Thank you KevinChant for suggesting this API.
Hope this helps. Please reach out for further assistance.
Thank you.
5 Replies
Have you tested if the refresh SQL endpoint API would resolve this?
Refresh SQL analytics endpoint Metadata REST API (Generally Available) | Microsoft Fabric Blog | Microsoft FabricHi lissethlopezl ,
Thank you for reaching out to the Microsoft fabric community forum.
Currently, the Lakehouse SQL Analytics Endpoint in Microsoft Fabric does not offer native logging capabilities to track the number of rows queried or detailed query execution history.
To address your need to verify how many rows were accessed via the SQL endpoint within a specific timeframe, you can consider enabling SQL audit logs (preview) in Fabric, which capture query activity, user access, and execution timestamps, though not row-level detail.
You can refer to the official documentation here: https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-audit-logs
Additionally, to validate the row count retrieved by a third-party tool, we recommend manually executing a SELECT COUNT(*) query with matching filters. If there’s a chance the SQL endpoint is not reflecting recent data due to metadata lag, you can use the Refresh SQL Analytics Endpoint Metadata API, which helps ensure the SQL endpoint is in sync with lakehouse updates. Also Thank you KevinChant for suggesting this API.
Hope this helps. Please reach out for further assistance.
Thank you.
Hi lissethlopezl ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.Thank you.
Hi lissethlopezl ,
I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.
Thank you.
Hi lissethlopezl ,
We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.Thank you.
