Getting Data In

Splunk DB Connect 1: Configuring my data input using select from both an HDR and DTL table, how can I specify which rising column will be used?

premdutt
Explorer

Hi

I have same AUD_UPDT_TMSTP column in my table HDR and DTL table and I am configuring my data input using select * from both tables' queries like ( HDR.* DTL.*).

[dbmon-tail://abc/db-cgw]
index = db-cgw-restricted
output.format = kv
output.timestamp = 0
output.timestamp.column = AUD_UPDT_TMSTP
query = SELECT HDR.* ,DTLS.* FROM CGW.MPM_HDR HDR RIGHT OUTER JOIN CGW.MPM_DTLS DTLS ON HDR.HDR_SKEY = DTLS.HDR_SKEY Where {{ HDR.$rising_column$ > ?}}
sourcetype = cgw-mpm-prod
disabled = 0
tail.rising.column = AUD_UPDT_TMSTP
table = db-mpm-prod

Question 1: Column from which table (HDR or DTL) will be used in rising column?
Question 2: How can we specify that rising column of DTL should be used instead of HDR?

thank you

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

I'm not sure this can work in DBX1 -- you're already trying the things I'd suggest. DBX2 might be more successful. If neither works, I'd suggest making a database view to combine the tables and then running DB Connect against that, or indexing both tables and combining in Splunk if that makes sense for the data in question (e..g time series events as opposed to tables full of current state).

0 Karma

premdutt
Explorer

SELECT HDR.* ,DTLS.* FROM CGW.MPM_HDR HDR RIGHT OUTER JOIN CGW.MPM_DTLS DTLS ON HDR.HDR_SKEY = DTLS.HDR_SKEY Where {{ HDR.$rising_column$ > ?}}

0 Karma

premdutt
Explorer

SELECT HDR.* ,DTLS.* FROM CGW.MPM_HDR HDR RIGHT OUTER JOIN CGW.MPM_DTLS DTLS ON HDR.HDR_SKEY = DTLS.HDR_SKEY Where {{ HDR.$rising_column$ > ?}}

0 Karma
Get Updates on the Splunk Community!

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...

4 Ways the Splunk Community Helps You Prepare for .conf25

.conf25 is right around the corner, and whether you’re a first-time attendee or a seasoned Splunker, the ...