Lakehouse SQL analytics endpoint logs

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.