All Apps and Add-ons

How to join the multiple database using SQL in Splunk

wongan3
Engager

Hi, how to join the multiple database using SQL in Splunk? Also, i would like to search in between 2 database and tables by comparing the fields. Thanks.

Tags (1)
0 Karma

pmdba
Builder

If you haven't already figured this out, from within Splunk you will need separate connections (and hence separate SQL queries) for each database. You would then have to use a Splunk search (not SQL) to compare the indexed results. There is no way that I am aware of to have a single SQL query run against two databases without taking advantage of a DB-to-DB server-to-server link.

Get Updates on the Splunk Community!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...