I am connecting to MS SQL server to fetch records into Splunk using Rising column. The rising column is a datetime column. When the execution runs then SplunkDBConnect pulls all available records, so first time it runs as expected. From the second poll it starts getting the last record again and hence leading to data duplication in Splunk environment.
My query is SELECT * FROM WHERE StartTime > ? ORDER BY StartTime ASC.
The coulmn StartTime has datetime datatype.
I also see updates going to checkpoint file. I currently poll every 60 seconds.