Uredi

Deli z drugimi prek

User audit logs for Microsoft Fabric Data Warehouse

  • Članek

Applies to: SQL analytics endpoint and Warehouse in Microsoft Fabric

To track user activity for meeting regulatory compliance and records managements requirements, a set of audit activities are accessible via Microsoft Purview and PowerShell. You can use user audit logs to identify who is taking what action on your Fabric items.

For more information on how to access user audit logs, visit Track user activities in Microsoft Fabric.

Permissions

You must be a tenant/global admin or auditor to have access to user audit logs.

Operations available in the user audit logs

The following operations are available in the user audit logs for Warehouse and SQL analytics endpoint activities.

Friendly name Operation name Notes
Created a Warehouse CreateWarehouse
Updated a Warehouse UpdateWarehouse
Updated metadata for a Warehouse UpdateWarehouseMetadata
Deleted a Warehouse DeleteWarehouse
Updated settings for a Warehouse UpdateWarehouseSettings
Updated parameters for a Warehouse UpsertWarehouseParameters
Viewed a Warehouse ViewWarehouse
Canceled a Warehouse batch CancelWarehouseBatch
Resumed a suspended Warehouse ResumeSuspendedWarehouse
Renamed a Warehouse RenameWarehouse
Shared a Warehouse ShareWarehouse
Connected to a Warehouse or SQL analytics endpoint from an external app ConnectWarehouseAndSqlAnalyticsEndpointLakehouseFromExternalApp Previously named "Connected to a warehouse or default warehouse from an external app" (Operation name: ConnectWarehouseAndDefaultWarehouseFromExternalApp)
Created a SQL query from a Warehouse CreateSqlQueryFromWarehouse
Created a visual query from a Warehouse CreateVisualQueryFromWarehouse
Deleted a SQL query from a Warehouse DeleteSqlQueryFromWarehouse This audit event covers both deleting SQL and visual queries from the Warehouse
Updated a SQL analytics endpoint UpdateSqlAnalyticsEndpointLakehouse Previously named "Updated a default warehouse" (Operation name: UpdateDefaultWarehouse)
Updated settings for a SQL analytics endpoint UpdateSqlAnalyticsEndpointLakehouseSettings Previously named "Updated settings for a default warehouse" (Operation name: UpdateDefaultWarehouseSettings)
Upserted parameters from a SQL analytics endpoint UpsertSqlAnalyticsEndpointLakehouseParameters Previously named "Updated parameters from a default warehouse" (Operation name: UpsertDefaultWarehouseParameters)
Viewed a SQL analytics endpoint ViewSqlAnalyticsEndpointLakehouse Previously named "Viewed a default warehouse" (Operation name: ViewDefaultWarehouse)
Canceled a SQL analytics endpoint batch CancelSqlAnalyticsEndpointlakehouseBatch Previously named "Canceled a default warehouse" (Operation name: CancelDefaultWarehouseBatch)
Resumed a suspended SQL analytics endpoint ResumeSuspendedSqlAnalyticsEndpointLakehouse Previously named "Resumed a suspended default warehouse" (Operation name: ResumeSuspendedDefaultWarehouse)
Refreshed metadata for a SQL analytics endpoint RefreshSqlAnalyticsEndpointLakehouseMetadata Previously named "Refreshed metadata for a default warehouse" (Operation name: RefreshDefaultWarehouseMetadata)
Created a SQL query from a SQL analytics endpoint CreateSqlQueryFromSqlAnalyticsEndpointLakehouse
Created a visual query from a SQL analytics endpoint CreateVisualQueryFromSqlAnalyticsEndpointLakehouse
Deleted a SQL query from a SQL analytics endpoint DeleteSqlQueryFromSqlAnalyticsEndpointLakehouse This audit event covers both deleting SQL and visual queries from the SQL analytics endpoint of the Lakehouse.

Related content