aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/TelemetryTable Ingestion Mapping.kql
diff options
context:
space:
mode:
Diffstat (limited to 'Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/TelemetryTable Ingestion Mapping.kql')
-rw-r--r--Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/TelemetryTable Ingestion Mapping.kql12
1 files changed, 12 insertions, 0 deletions
diff --git a/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/TelemetryTable Ingestion Mapping.kql b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/TelemetryTable Ingestion Mapping.kql
new file mode 100644
index 000000000..cb4f2f026
--- /dev/null
+++ b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/TelemetryTable Ingestion Mapping.kql
@@ -0,0 +1,12 @@
+.alter table TelemetryTable ingestion json mapping 'telemetryMapping' ```[
+ { "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":"Telemetry", "path":"$.Telemetry" }
+]``` \ No newline at end of file