Manage Azure Synapse Analytics auditing by using APIs

You can manage Azure Synapse Analytics auditing at the server or database level by using PowerShell, the Azure CLI, or REST APIs.

PowerShell

Use the following Az.Sql cmdlets for Synapse SQL auditing:

• Set-AzSqlDatabaseAudit
• Set-AzSqlServerAudit
• Get-AzSqlDatabaseAudit
• Get-AzSqlServerAudit
• Remove-AzSqlDatabaseAudit
• Remove-AzSqlServerAudit
• Set-AzSqlServerMSSupportAudit

REST API

Use the following resources to create, retrieve, or update auditing policies:

• Create or Update Database Auditing Policy
• Create or Update Server Auditing Policy
• Create or Update Microsoft support operations audit policy
• Get Database Auditing Policy
• Get Server Auditing Policy

Extended policy with WHERE clause support for additional filtering:

• Create or Update Database Extended Auditing Policy
• Create or Update Server Extended Auditing Policy
• Get Database Extended Auditing Policy
• Get Server Extended Auditing Policy

Azure CLI

• Manage a server auditing policy
• Manage a database auditing policy
• Manage a Microsoft support operations auditing policy

Related content

• Auditing in Azure Synapse Analytics
• Set up auditing for Azure Synapse Analytics
• Auditing policy at the server and database level