Excel Add-In for Elasticsearch

Build 24.0.9060

Parsing Hierarchical Data

The add-in offers three basic configurations to model documents as tables, described in the following sections. The add-in will parse the Elasticsearch document and identify the nested documents.

  • Flattened Documents Model: Implicitly join nested documents into a single table.
  • Relational Model: Model nested documents as individual tables containing a primary key and a foreign key that links to the parent document.
  • Top-Level Document Model: Model a top-level view of an Elasticsearch document. Nested documents are returned as JSON strings.
See Searching with SQL to configure column discovery or customize the detected schemas.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060