I have a pipeline that uses a JDBC Query Consumer, running in incremental mode. The source table is in MSSQL.
My offset column is in datetime type, and is never null (although nullable).
While the job is running, I can retrieve the offset values in the GUI. However, after the job finishes successfully, when I try to retrieve the offset values, the result is empty.
In the data table, there are about 250k records, belonging to 5 distinct dates. I can’t see why the latest offset cannot be saved.
In the select query, I have this → SELECT * FROM dbo.PHIN_Bankruptcy_Load WHERE ReportDate > '${OFFSET}' ORDER BY ReportDate
I would appreciate any tip that can help me overcome this problem - how to make the pipeline save the offset at the end of the run?