Getting Data In

How can we deal with tables that don’t have a rising column?

danielbb
Motivator

In DB Connect we have situations where we don’t have a rising column. What can we do in such cases?

Labels (1)
Tags (1)
0 Karma

tscroggins
Influencer

@danielbb 

Can you provide a more detailed example of your use case? You can use a batch input to periodically read all rows, but your question implies a need to index newly inserted and/or updated rows.

Some DBMS products provide internal timestamp columns.

A batch input may be acceptable for small tables.

A scheduled search combining a key column lookup cache, dbxquery, a differencing operation, and collect may also be acceptable; however, a target table that contains duplicate foreign keys but no unique key column may be difficult to track.

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...