Archive

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?

Explorer

Hi

I have same AUDUPDTTMSTP 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

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

Explorer

SELECT HDR.* ,DTLS.* FROM CGW.MPMHDR HDR RIGHT OUTER JOIN CGW.MPMDTLS DTLS ON HDR.HDRSKEY = DTLS.HDRSKEY Where {{ HDR.$rising_column$ > ?}}

0 Karma

Explorer

SELECT HDR.* ,DTLS.* FROM CGW.MPMHDR HDR RIGHT OUTER JOIN CGW.MPMDTLS DTLS ON HDR.HDRSKEY = DTLS.HDRSKEY Where {{ HDR.$rising_column$ > ?}}

0 Karma