elasticsearch-tableau-connector
elasticsearch-tableau-connector copied to clipboard
Support for array types
I know the readme says these are ignored, but I figure this isn't desirable and I didn't see an existing issue for it, so here we are :)
Could you provide any more details of what you think the expected behavior should be for array types? How would you expect those to show up in Tableau (and what Tableau data type should they be mapped to?)
For a custom need that we have, we decided that if we have an array of strings in ES, we squash it into a comma-delimited string. I don't know if this would be generic enough to be useful to someone else but it could be a first idea about this.
https://github.com/maximeloizeau/elasticsearch-tableau-connector/commit/01ec3e9145531df8a54fc1748416dc867c716afe
Based on how the JSON connector works in Tableau, you could make duplicate records, one for each element of the array. See https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_json.html