# How to have a checkpoint using a TimeStamp field (sql\_last\_value)

**URL:** <https://discuss.elastic.co/t/how-to-have-a-checkpoint-using-a-timestamp-field-sql-last-value/215745>\
**Category:** Logstash\
**Created:** [January 20, 2020, 1:51pm UTC](https://discuss.elastic.co/t/how-to-have-a-checkpoint-using-a-timestamp-field-sql-last-value/215745 "2020-01-20T13:51:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![NaveenSilvester](https://avatars.discourse-cdn.com/v4/letter/n/46a35a/32.png) [@NaveenSilvester](https://discuss.elastic.co/u/NaveenSilvester)\
**Post date:** [January 20, 2020, 1:51pm UTC](https://discuss.elastic.co/t/how-to-have-a-checkpoint-using-a-timestamp-field-sql-last-value/215745/1 "2020-01-20T13:51:04Z")

</div>

Hi ELK community,  
Here is a challenge that I am facing while tracking a TimeStamp filed in logstash.

I am connecting to Postgresql table which has a field named "Recorded\_time" with a datatype TimeStamp.  
I want to have this field as the tracking field in my Logstash configuration file.  
Here is the challenge that I am currently facing and need help from the community.  
The sql\_last\_value of the tracked column "Recorded\_time" is not getting saved in the file "logstash\_jdbc\_last\_run\_t\_data.txt" (_refer to the config file detail: last\_run\_metadata\_path =\> "C:/ELK/logstash\_jdbc\_last\_run\_t\_data.txt"_)

For your reference here is an Example: Value stored in the column "Recorded\_time" = "2018-01-28 04:22:59.171428-05"

**Here is how my Config file looks like.**

use\_column\_value =\> true  
tracking\_column =\> recorded\_time  
record\_last\_run =\> true  
tracking\_column\_type =\> "timestamp"  
jdbc\_default\_timezone =\> "US/Eastern"  
last\_run\_metadata\_path =\> "C:/ELK/logstash\_jdbc\_last\_run\_t\_data.txt"

**Any help on this is highly appreciated.**

Thanks,  
Naveen Silvester

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 17, 2020, 1:51pm UTC](https://discuss.elastic.co/t/how-to-have-a-checkpoint-using-a-timestamp-field-sql-last-value/215745/2 "2020-02-17T13:51:04Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.