Hi, i want to do a historical extract from a table like this

defaults:
  mode: incremental
  object: dbo.{stream_table}
  source_options:
    range: '2024-09-01,2024-12-31'
    chunk_size: 1d

the target table has not been created on the destination target as i expect sling when create the destination table. The issue is instead of using the start and end date from range, sling instead create a new range from year 0000-01-01 to year 2024-12-31. So now my workaround is pulling the first data (2024-09-01) and the use the incremental with range replication https://cdn.discordapp.com/attachments/1210406123744796705/1473611247088963687/image.png?ex=6998286b&is=6996d6eb&hm=c1bb61aaa90af339ec3f7ecc4836fc0efac5b28e647967a46e2c167888d9bc18&

@paradiso interesting, could you share debug logs so I look into this?

hello, sorry for the late response and this is the replication file

source: oracle_housekeeping
target: bigquery

defaults:
  mode: incremental

streams:
  WAY4TS_H.DOC:
    object: playground.table_1
    update_key: column_DATE
    source_options:
      range: '2024-09-02,2024-12-31'
      chunk_size: 1d
    target_options:
      file_max_rows: 5000000
      column_casing: source
env:
  SLING_THREADS: 6

https://cdn.discordapp.com/attachments/1473611247365914708/1475347591339446292/image.png?ex=699d2804&is=699bd684&hm=ab5355c4ed35a3fb7108528f064a96ddd336e27e6d44d23a17a2ca6ac7786a78&

OK, thanks for reporting, I was able to reproduce and apply a fix for next imminent release.