Stream Analytics job should use latest compatibility level

Medium Azure General streamingjobs-stream-analytics-job-latest

Applies to

Microsoft.StreamAnalytics/streamingjobs

What CGPulse checks

A resource passes this rule when compatibilityLevel must equal 1.2. Anything else is reported as a finding with the evaluated property value attached as evidence.

How to fix it

Upgrade to compatibility level 1.2 for the latest security and feature improvements. In Azure Portal: Stream Analytics job > Configuration > set Compatibility level to 1.2. See: https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-compatibility-level

CLI

az stream-analytics job update --ids "{id}" --compatibility-level 1.2

Terraform

resource "azurerm_stream_analytics_job" "{name}" {
  name                                     = "{name}"
  resource_group_name                      = "{rg}"
  location                                 = var.location
  compatibility_level                      = "1.2"
  streaming_units                          = 3
  transformation_query                     = "SELECT * INTO [output] FROM [input]"
}

Compliance frameworks

Cloud Security: Azure Foundations

Is your environment compliant with this rule?

CGPulse checks it — and 621 others — against your Azure and AWS accounts with read-only access.

Run a free scan