Is Opensearch 1.2.4 along with JDBC driver 220.127.116.11 compatible for retrieving and analysing data in Tableau?
I tried this JDBC driver in DbVisualizer and there are errors parsing columns of type OBJET, Unknown Type (2.002), these are the root / intermediate nodes of the fetched JSON records, that prevents the rest of the columns to show correctly. This does not happen, it woks properly, in an ElasticSearch with license and Elastic JDBC driver.
My guess is that the problem lies in the JDBC side, OpenSearch JDBC driver is missing something to properly parse fetched JSON records, relative to root / intermediate nodes. Maybe ElasticSearch JDBC Driver is ignoring them and only parses final nodes to columns.
Opensearch [Opensearch 1.2.4 + Opensearch JDBC Driver 18.104.22.168]:
Elastic [ElasticSearch JDBC Driver + ElasticSearch with license]