Data ModelCData JDBC Driver for Elasticsearch 2019 - Build 19.0.7354
The CData JDBC Driver for Elasticsearch 2019 models Elasticsearch entities in relational Tables, Views, and Stored Procedures.
TablesThe table definitions are dynamically retrieved. When you connect, the driver connects to Elasticsearch and retrieves the schemas, list of tables, and the metadata for the tables by querying the Elasticsearch REST server.
Searching with SQL describes in further detail how the tables are dynamically retrieved.
ViewsViews are created from Elasticsearch aliases and the definitions are dynamically retrieved. When you connect, the driver connects to Elasticsearch and retrieves the list of views and the metadata for the views by querying the Elasticsearch REST server.
Views are treated in a similar manner to Tables and thus exhibit similar behavior. There are some differences behind the scenes though which are a direct result of how aliases work within Elasticsearch. (Note: In the following description, 'alias', 'index', 'type', and 'field' are referring to the Elasticsearch objects and not directly to anything within the driver).
Views (aliases) are tied to an index and thus span all the types within an index. Additionally aliases can span multiple indices. Therefore you may see an alias (view) listed multiple times under different schemas (index). When querying the view, regardless of the schema specified, data will be retrieved and returned for all indices and types associated with the corresponding alias. Thus the generated metadata will contain a column for each field within each type of each index associated with the alias.
Searching with SQL describes in further detail how the views are dynamically retrieved.
The ModifyIndexAliases stored procedure can be used to create index aliases within Elasticsearch.
In addition to the Elasticsearch aliases, an '_all' view is returned which enables querying the _all endpoint to retrieve data for all indices in a single query.