All Apps and Add-ons

Splunk to Tableau Connector Issue

ankitsetyaaexp
New Member

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?

Tags (1)
0 Karma

xpac
SplunkTrust
SplunkTrust

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:

  • Save your search, schedule it, wait until it ran at least once
  • Create a second search, using this query: | 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. 🙂

0 Karma

eugenek
Path Finder

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.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Keep the Learning Going with the New Best of .conf Hub

Hello Splunkers, With .conf26 getting closer, there’s already a lot of excitement building around this year’s ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

How to find the worst searches in your Splunk environment and how to fix them

Everyone knows Splunk is a powerful platform for running searches and doing data analytics. Your ...