Ingesting JSON formatted data into Azure Data Explorer

This post has been republished via RSS; it originally appeared at: Azure Data Explorer articles.

Did you know that you can ingest JSON formatted data into Azure Data Explorer?

Start by setting up a cluster and database, and then decide which JSON file format your source data is in: JSON, or multiJSON. It makes a difference because with JSON, each line in the input data has one JSON record, but for multiJSON, the parser reads a record from the previous position to the end of a valid JSON.

When you ingest JSON formatted data, you'll need to specify the format and map the JSON source entry to its target column using data mapping.

You can use KQL, and other languages to ingest many types of records and arrays.

Read more about this topic with examples and sample data.

Related information:

  1. Ingesting data using the Azure Data Explorer Python library
  2. Ingesting data using the Azure Data Explorer .NET Standard SDK
  3. How to create a cluster and database
  4. Using the ingestion property

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.