Forum Discussion

davidwoodbourne's avatar
davidwoodbourne
New Member
3 years ago

DataMart Auditing

Hi All,

 

I'm investigating the usage of @datamarts within my organisation, and will be rolling it out to to a few departments as a proof of concept.  One of the areas i'm particulary interested in is with regards to the level of auditing available in DataMart.  

 

I'd like to provide business analysts of one of the departments during this PoC with the ability to use the Native Sql feature against the data mart and export to excel.  

 

As the engine behind DataMarts is Azure Database is there any way to audit who has excuted queries against the data whether from within PowerBI or SQL Server Endpoint?  Does anybody feel there is a lack of auditing currently with DataMarts?

 

Thanks David

 

 

Need Help

1 Reply

  • MAwwad's avatar
    MAwwad
    Solution Sage
    3 years ago

    Yes, auditing of activity in a DataMart can be done using Azure Database auditing. Azure Database Auditing tracks database events and writes them to an audit log in Azure Log Analytics or Azure Storage. You can enable auditing at the database or server level and select the events you want to audit, such as SQL statements executed, data written or modified, and error events.

    You can also set up Azure Monitor Alerts to receive notifications of specific audit events, such as when a user accesses or modifies sensitive data.