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!

Introducing the Splunk Developer Program!

Hey Splunk community!  We are excited to announce that Splunk is launching the Splunk Developer Program in ...

Splunkbase Year in Review 2024

Reflecting on 2024, it’s clear that innovation and collaboration have defined the journey for Splunk ...

Developer Spotlight with Brett Adams

In our third Spotlight feature, we're excited to shine a light on Brett—a Splunk consultant, innovative ...