A recent customer issue showing discrepancies across their source data and transforms was a result from missing or late arriving records in a data load. Therefore we should at add a lookback window to our incremental models to help capture that data in a given window.
Is there an existing issue for this?
Describe the issue
A recent customer issue showing discrepancies across their source data and transforms was a result from missing or late arriving records in a data load. Therefore we should at add a lookback window to our incremental models to help capture that data in a given window.
https://docs.getdbt.com/best-practices/materializations/4-incremental-models#late-arriving-facts
Relevant error log or model output
No response
Expected behavior
All data is captured! 🙏
dbt Project configurations
na
Package versions
na
What database are you using dbt with?
other (mention it in "Additional Context")
dbt Version
na
Additional Context
No response
Are you willing to open a PR to help address this issue?