# When is sql\_last\_value updated?

**URL:** <https://discuss.elastic.co/t/when-is-sql-last-value-updated/174850>\
**Category:** Logstash\
**Created:** [April 1, 2019, 7:07pm UTC](https://discuss.elastic.co/t/when-is-sql-last-value-updated/174850 "2019-04-01T19:07:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ed.sam13](https://avatars.discourse-cdn.com/v4/letter/e/eb8c5e/32.png) [@ed.sam13](https://discuss.elastic.co/u/ed.sam13)\
**Post date:** [April 1, 2019, 7:07pm UTC](https://discuss.elastic.co/t/when-is-sql-last-value-updated/174850/1 "2019-04-01T19:07:02Z")

</div>

We are using Logstash with JDBC input plugin and Elastic search as output. If - for example, we start the full data import from DB at 9am and the import completes at 11am, what gets updated as the sql last value on the file? Is it 9am or 11am? If it is 11am, what happens to the updates between 9am and 11am?

---

<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:** [April 29, 2019, 7:07pm UTC](https://discuss.elastic.co/t/when-is-sql-last-value-updated/174850/2 "2019-04-29T19:07:17Z")

</div>

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