thank you for details!
Could you also please let me know, if you have this information: if in log4j logs in autoloader stream I see this output:

25/11/26 14:06:46 INFO IncrementalListingUtils: [queryId = ffdd9] [batchId = 58] Checked whether or not to use incremental listing. numBackfills: 0, [minBackfillsRequired: 5] outOfOrderFileRatio: 0.0, [outOfOrderFileThreshold: 0.05]
useIncrementalListing: false
autoDetectResult: 2

does it mean incremental listing is not being used after checking if it's possible?