.alter table MachineStatusesTable policy update @'[{"IsEnabled": true,"Source": "TelemetryTable","Query": "let raw = materialize(TelemetryTable | where Type == \"MachineStatus\" | extend payload = todynamic(Telemetry) | extend s = payload[\"Status\"] | project SerialNumber, MachineType, Environment, Organization, Site, CreatedTime, UploadTime, State = tostring(s[\"State\"]), OverallTemperature = todouble(s[\"OverallTemperature\"]), Status = s); raw","IsTransactional": false,"PropagateIngestionProperties": true}]'