Manage Azure Synapse Analytics auditing by using APIs

Tip

Microsoft Fabric Data Warehouse is an enterprise scale relational warehouse on a data lake foundation, with a future-ready architecture, built-in AI, and new features. If you're new to data warehousing, start with Fabric Data Warehouse. Existing dedicated SQL pool workloads can upgrade to Fabric to access new capabilities across data science, real-time analytics, and reporting.

• Start a Fabric free trial.
• Migration Assistant for Fabric Data Warehouse.

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