Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Is SQL level auditing available for lakehouses yet? So far I'm only seeing that SQL auditing is available in Data Warehouse and SQL Database. Is there any other Fabric tool that has SQL level auditing that I missed?
What I see right now
Solved! Go to Solution.
Hi @BriefStop ,
Right now, SQL-level auditing isn’t available for the Lakehouse SQL endpoint. What you’re seeing is correct — the auditing features you mentioned only apply to Fabric Data Warehouse and the dedicated SQL Database experience. The Lakehouse SQL endpoint is still missing the deeper auditing layer that tracks individual queries.
At the moment the only things you can rely on are the general workspace activity logs, which show high-level operations, not full SQL statements. There isn’t another tool in Fabric today that gives you true SQL-level auditing for Lakehouse queries.
Hopefully this is something Microsoft adds as the Lakehouse SQL endpoint matures, but as of today there’s no built-in, detailed auditing option for it.
– Gopi Krishna
Hi @BriefStop ,
Right now, SQL-level auditing isn’t available for the Lakehouse SQL endpoint. What you’re seeing is correct — the auditing features you mentioned only apply to Fabric Data Warehouse and the dedicated SQL Database experience. The Lakehouse SQL endpoint is still missing the deeper auditing layer that tracks individual queries.
At the moment the only things you can rely on are the general workspace activity logs, which show high-level operations, not full SQL statements. There isn’t another tool in Fabric today that gives you true SQL-level auditing for Lakehouse queries.
Hopefully this is something Microsoft adds as the Lakehouse SQL endpoint matures, but as of today there’s no built-in, detailed auditing option for it.
– Gopi Krishna
HI @BriefStop ,
Thank you for reaching out to the Microsoft Community Forum.
Hi @Ugk161610 , Thank you for your prompt response.
Hi @BriefStop could you please try the proposed solution shared by @Ugk161610 ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
Hi @BriefStop ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 7 | |
| 3 | |
| 3 | |
| 3 | |
| 3 |