I'm using the ODBC driver to connect Tableau to Elasticsearch and ran into this. Through trial and error, the user connected to the driver needs to have the
manage role in order to pull in the "tables" from ES. I tried by giving only
monitor privs for the indices, but Tableau couldn't find the names of the indices I needed with only those two.
manage priv, it says it has:
All monitor privileges plus index administration (aliases, analyze, cache clear, close, delete, exists, flush, mapping, open, force merge, refresh, settings, search shards, templates, validate).
I'd love it if I could exclude the
delete priv and keep the other ones open. Is there any way to do a custom one?
This is definitely a problem for anyone using the Tableau connector to ES and has users with different permission levels because they need to have this priv in order to make the connection to indices happen at all.