Experience the New Visual SQL Audit Logs Configuration in Fabric Warehouse
In April, we announced the preview of SQL Audit Logs for Microsoft Fabric Data Warehouse, giving organizations the power to track and retain critical warehouse events for enhanced visibility and control. Today, we’re taking that experience to the next level. We’re introducing an all-new, intuitive visual experience—making it easier than ever to configure, enable, and manage SQL Audit Logs right from the Fabric Warehouse interface.
This update is all about putting control in your hands: now you can set up and customize your auditing strategy without the need for scripts or advanced setup, bringing clarity, flexibility, and efficiency to your governance workflows.
A Closer Look at the New Experience
SQL Audit Logs UI highlights:
1. Effortless Activation & Configuration – With a simple toggle, you can enable audit logging and immediately access configuration options—all from a single pane.
2. Granular Event Selection – Select which events you want to record using a user-friendly, categorized interface. Choose from authentication events, data access activities, and administrative actions to align auditing precisely with your organization’s policies.
Tip: All events are enabled by default for comprehensive coverage. However, we recommend selecting only the actions your organization truly needs—capturing all events can generate large volumes of logs and may impact storage costs.
You can also expand each section to choose individual action groups, allowing you to capture only what is most relevant for your compliance and security requirements.
3. Flexible Log Retention – Define how long you want to retain your audit logs in OneLake, with just a few clicks. Whether your requirements call for short-term storage or up to nine years of retention, the UI validates your settings and makes compliance easy.
With this new experience, we’re responding directly to customer feedback—making SQL Audit Logs not only powerful, but approachable and easy to maintain. Whether you’re a data engineer, security admin, or analytics lead, this visual update ensures that audit logging in Fabric Warehouse is efficient, transparent, and ready to meet your organization’s evolving needs.
Learn more
Explore our documentation for an in-depth look at these features.
