_sdc_batched_at is set consistently per batched load into redshift.
Actual
_sdc_batched_at is set to the current time when the row was processed, this results n distinct values where n is the number of rows processed. This means that to do any kind of comparison on the batch a datetime operator needs to be used.
Expected
_sdc_batched_at is set consistently per batched load into redshift.
Actual
_sdc_batched_at is set to the current time when the row was processed, this results
ndistinct values wherenis the number of rows processed. This means that to do any kind of comparison on the batch a datetime operator needs to be used.