Lakehouse SQL analytics endpoint logs

[lissethlopezl]

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.

[v-tsaipranay]

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.

[v-tsaipranay]

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.

[v-tsaipranay]

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.

[v-tsaipranay · Accepted solution]

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.

[KevinChant]

Have you tested if the refresh SQL endpoint API would resolve this?

Refresh SQL analytics endpoint Metadata REST API (Generally Available) | Microsoft Fabric Blog | Mic...