1
|
.create-or-alter table JobStatusTable ingestion json mapping 'JobStatusJsonMapping' '[{"column":"Type","path":"$.Type"},{"column":"Version","path":"$.Version"},{"column":"Environment","path":"$.Environment"},{"column":"MachineType","path":"$.MachineType"},{"column":"SerialNumber","path":"$.SerialNumber"},{"column":"Organization","path":"$.Organization"},{"column":"Site","path":"$.Site"},{"column":"UploadTime","path":"$.UploadTime"},{"column":"CreatedTime","path":"$.CreatedTime"},{"column":"ID","path":"$.Telemetry.ID"},{"column":"JobName","path":"$.Telemetry.JobName"},{"column":"Status","path":"$.Telemetry.Status"},{"column":"TotalTime","path":"$.Telemetry.TotalTime"},{"column":"RemainingTime","path":"$.Telemetry.RemainingTime"},{"column":"Progress","path":"$.Telemetry.Progress"},{"column":"TotalProgress","path":"$.Telemetry.TotalProgress"},{"column":"CurrentUnit","path":"$.Telemetry.CurrentUnit"},{"column":"RemainingUnits","path":"$.Telemetry.RemainingUnits"},{"column":"CurrentUnitProgress","path":"$.Telemetry.CurrentUnitProgress"},{"column":"CurrentUnitTotalProgress","path":"$.Telemetry.CurrentUnitTotalProgress"},{"column":"Message","path":"$.Telemetry.Message"}]'
|
