Forum Discussion
SQL Query Auditing for Lakehouse
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
Hi Anonymous ,
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
3 Replies
Hi Anonymous ,
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 Anonymous ,
Thank you for reaching out to the Microsoft Community Forum.
Hi Ugk161610 , Thank you for your prompt response.
Hi Anonymous 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 Anonymous ,
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
