Write an incremental SQL extraction query for our orders pipeline. To protect against late-arriving records, extract all rows from source_orders where updated_at is greater than or equal to the previous watermark minus a 1-hour lookback window, and strictly less than the current execution batch cutoff timestamp.
Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.
Run your code to see the result here.