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!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...