Re: How to migrate from Elasticsearch to Azure Data Explorer

Posting the ADX table and json mapping commands used in the pipeline for reference.

.create tables people(name:string,age:int,place:string, timestamp:timespan ) 

.create table people ingestion json mapping 'peoplemapping' '[{"column":"name","path":"$.name"},{"column":"age","path":"$.age"} ,{"column":"place","path":"$.place"}]'

.create tables city(name:string,state:string,country:string, timestamp:timespan ) 

.create table city ingestion json mapping 'citymapping' '[{"column":"name","path":"$.name"},{"column":"state","path":"$.state"} ,{"column":"country","path":"$.country"}]'