Elastic search and Tableau Integration using ODBC

Elastic Stack Elasticsearch
1

Hi, I am facing few issues when accessing my data set from Elastic search to Tableau. Few fields in my data set do not support live in tableau. I know that the ODBC is still under development, when can I expect the stable version? i have also tried the Dremio, but it still doesn't work. Is there any way to fix it?

2

Would you be able to provide more details about which fields are not supported and what error messages you are seeing?

Your feedback on this would be super useful here and this additional detail would help understand where the underlying issue is.

/cc @bogdan.pintea

3

In my data set of kibana sample flight data, timestamp field and measure values are not supported. Also I have tried multiple data sets but the issue is the same. Other custom fields like calculated fields are also not supported in live but are supported in extract.

Thank You.

Screenshot%20(11)

Screenshot%20(12)
Screenshot (12).png1434×885 75.5 KB

4

Screenshot%20(15)
Screenshot (15).png1529×943 75.2 KB

In this picture I have created a COUNTD() calculation field in live. The issue is with ODBC in live. I am facing the same problem even with the Microsoft Power BI.

Thank You.

5

Thanks for trying out our SQL implementation.

There seems to be a defect here in the way we handle the GROUP BY in the statement generated by Tableau. I've opened an issue to follow-up on this (https://github.com/elastic/elasticsearch/issues/40001).

Thanks for bringing it up to us.

6

This should normally work, except for the case a field contains an array of values (vs. just one value). We have an issue tracking this already (https://github.com/elastic/elasticsearch/issues/39700) and hope to have soon a solution for it.
Could this be the case with the bank.lastname index?