Search code examples
jsoncsvazure-data-explorerkqldata-mapping

How to set ingestion mapping for TSV or W3CLOGFILE format in Kusto database in Azure Data Explorer?


I am relatively new to Kusto. I was wondering how do we specify ingestion mappings in Kusto for formats other than CSV, JSON, AVRO, ORC, or Parquet. I could see examples only for these data formats in the documentation. I want to create an ingestion mapping for TSV or W3CLOGFILE format, and ingest data through the built-in pipeline in ADX from azure blob storage.


Solution

  • For TSV it is the same as CSV, see relevant doc comment:

    CSV mapping can be applied on all the delimiter-separated formats: CSV, TSV, PSV, SCSV, and SOHsv.

    As for W3CLOGFILE, the mapping format is the same as for AVRO mapping