I am trying connect Splunk data to Tableau Desktop. I have accelerated the saved search but tableau is not retrieving the accelerated results from Splunk, but rerunning the saved search query. Hence, I do not get all fields when I pull data from Splunk to Tableau. How do we access the accelerated results in Tableau?
I'm not a Tableau professional, so you might be better off asking in a Tableau community or their support, but I've given it a quick look.
As far as I see you can only tell Tableau to load a certain saved search, but it doesn't support to load the results from a scheduled run.
You could however try this:
| loadjob savedsearch="MyUser:MyApp:MySavedSearch"
You obviously have to replace MyUser
, MyApp
and MySavedSearch
- this search should simply load the last result from your other search. You can then refer to the second search from Tableau.
Hope that helps - if it does I'd be happy if you would upvote/accept this answer, so others could profit from it. 🙂
We came to a similar conclusion. The additional benefit is that the account you use to access Splunk from Tableau does not need access to the indexes queried by the initial search. As long as it has permissions to see the results of the first query, it can use loadjob.