Data Lab SQL Input - Temp Table Alternatives

Getting Data In

Hello,

I have taken on a project at work to migrate all of our old MSSQL reports into Splunk. The SQL in these reports are incredibly long - like college essay long. When I copy it directly into Data Labs input, I get this error:

com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.

I assume that this is caused by the SQL creating 4 different temp tables during its search. If this is the case, is there a simple recommended alternative? I was looking at possibly outputcsv, but think it may over complicate it with there being so many different temp tables.

Thanks

Get Updates on the Splunk Community!

Splunk Enterprise Security: An Automated Phishing Response Workflow

Originally posted on Splunk.com. Key takeaways The volume of phishing emails can overwhelm even the most ...

Sharper ES Detections, Agentic AI Integrations, Smarter Workload Management, and More ...

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...

Data Outage Monitoring and Reporting

We’ve all been there, right? Living our best life, working on our Splunk environment, when out of nowhere a ...