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 read and monitor privs for the indices, but Tableau couldn't find the names of the indices I needed with only those two.
Under the 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.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.