There is inserted_time column and username column in a mysql table. I have to pick the new records daily from mysql.
I want to use inserted_time as a tracking column and use sql_last_value.
but inserted_time is not unique . fields username+inserted_time is unique.
Now is it possible to have tracking_column=> inserted_time and document_id=> username+inserted_time. Will there be any data loss or data duplicates ?
Do we have to keep both tracking_column and document_id as same?