Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

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 auditin...
data engineering
Lakehouse
  • Ugk161610's avatar
    Ugk161610
    8 months ago

    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

Ugk161610's avatar
Ugk161610
Super User
8 months ago

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

  • v-dineshya's avatar
    v-dineshya
    Community Support
    8 months ago

    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

    • v-dineshya's avatar
      v-dineshya
      Community Support
      8 months ago

      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