Hi @amirabedhiafi,

Thank you for your answer, I found it very helpful. It actually gave me an idea.

What if I use a database backup for the initial load instead of performing the first backfill step? This way, I could ingest all the historical data at once, and then store the last insert timestamp in the bronze Delta table to use it as a starting point for the continuous ingestion.

Do you think this approach would be reliable, or could it introduce consistency issues compared to using a defined cutoff point?