last sync: 2024-Sep-18 17:50:24 UTC

Synapse workspaces with SQL auditing to storage account destination should be configured with 90 days retention or higher

Azure BuiltIn Policy definition

Source Azure Portal
Display name Synapse workspaces with SQL auditing to storage account destination should be configured with 90 days retention or higher
Id 529ea018-6afc-4ed4-95bd-7c9ee47b00bc
Version 2.0.0
Details on versioning
Versioning Versions supported for Versioning: 1
2.0.0
Built-in Versioning [Preview]
Category Synapse
Microsoft Learn
Description For incident investigation purposes, we recommend setting the data retention for your Synapse workspace' SQL auditing to storage account destination to at least 90 days. Confirm that you are meeting the necessary retention rules for the regions in which you are operating. This is sometimes required for compliance with regulatory standards.
Mode Indexed
Type BuiltIn
Preview False
Deprecated False
Effect Default
AuditIfNotExists
Allowed
AuditIfNotExists, Disabled
RBAC role(s) none
Rule aliases THEN-ExistenceCondition (3)
Alias Namespace ResourceType Path PathIsDefault DefaultPath Modifiable
Microsoft.Synapse/workspaces/auditingSettings/isAzureMonitorTargetEnabled Microsoft.Synapse workspaces/auditingSettings properties.isAzureMonitorTargetEnabled True False
Microsoft.Synapse/workspaces/auditingSettings/retentionDays Microsoft.Synapse workspaces/auditingSettings properties.retentionDays True False
Microsoft.Synapse/workspaces/auditingSettings/storageEndpoint Microsoft.Synapse workspaces/auditingSettings properties.storageEndpoint True False
Rule resource types IF (1)
Microsoft.Synapse/workspaces
Compliance
The following 1 compliance controls are associated with this Policy definition 'Synapse workspaces with SQL auditing to storage account destination should be configured with 90 days retention or higher' (529ea018-6afc-4ed4-95bd-7c9ee47b00bc)
Control Domain Control Name MetadataId Category Title Owner Requirements Description Info Policy#
op.exp.8 Recording of the activity op.exp.8 Recording of the activity 404 not found n/a n/a 67
Initiatives usage
Initiative DisplayName Initiative Id Initiative Category State Type
Spain ENS 175daf90-21e1-4fec-b745-7b4c909aa94c Regulatory Compliance GA BuiltIn
History
Date/Time (UTC ymd) (i) Change type Change detail
2021-03-24 14:32:48 change Major (1.0.0 > 2.0.0)
2021-03-09 14:37:41 add 529ea018-6afc-4ed4-95bd-7c9ee47b00bc
JSON compare
compare mode: version left: version right:
JSON
api-version=2021-06-01
EPAC