FabricLakehouseQueryLogs

Hi yongshao ,

Thanks for reaching out to the Microsoft Fabric Community.

At the moment, there doesn’t appear to be a setting called FabricLakehouseQueryLogs under Workspace Monitoring or the Fabric Admin Portal > Tenant Settings.

However, there are a few options that might help track Lakehouse SQL query activity.

You can try setting up diagnostic settings on your Lakehouse in the Azure portal to send logs to Log Analytics. If logs are flowing correctly, you might be able to run KQL queries in Log Analytics to view query activity.

For more details, please visit this link: Solved: Re: Lakehouse End User Usage - Microsoft Fabric Community

Also, if you go to the Lakehouse SQL endpoint and click the three dots, there should be an option called Query Activity. That view shows details like the query text, submit time, duration, status, submitter, session ID, and run source.

You could also check if the Fabric Capacity Metrics app gives some of the usage insights you're looking for.

Some useful links:

Monitor a data warehouse in Microsoft Fabric | mslearn-fabric

Solved: Re: Lakehouse End User Usage - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.

Thank you.