How should I use sql_last_value in logstash?

I suspect you've run the plugin at least once before setting tracking_column, so Logstash has saved a timestamp in ~/.logstash_jdbc_last_run but never updates that file since it never gets any results for the resulting query. Try deleting the file or changing it to the id where you want to start.

1 Like