Forum Discussion
FabricH
1 year agoFrequent Visitor
SQL Audit Logs
I tried to enable logging of UPDATE-Statements for the Warehouse (SQL Audits). I don't want to include SELECT-Statements, since this would increasy the volume of actions that are logged. Bases on ...
FabricH
1 year agoFrequent Visitor
Thanks. The response returns "enabled".
I included the empty line after the bearer token (somehow removed it in this post).
In general, it works for audit action groups.
However, I am not able to only capture UPDATE statements without capturing SELECT statements.
v-nmadadi-msft
1 year agoCommunity Support
Hi FabricH ,
Can you confirm if your Warehouse is using snapshots which is also in preview, there is a limitation where SQL Audit logs is not supported in Warehouse Snapshots.
I hope this information helps. Please do let us know if you have any further queries.
Thank you