Some records show are included in the end model despite being marked as fivetran_deleted. This may because these were soft deleted, rather than hard-deleted. Possibly due to accounting auditing purposes. Maybe we want to filter these out in the end models.
Relevant error log or model output
No response
Expected behavior
Don't include values from records that were soft-deleted
dbt Project configurations
n/a
Package versions
0.1.0
What database are you using dbt with?
bigquery
dbt Version
1.0.0
Additional Context
No response
Are you willing to open a PR to help address this issue?
[X] Yes.
[ ] Yes, but I will need assistance and will schedule time during our office hours for guidance
Is there an existing issue for this?
Describe the issue
Some records show are included in the end model despite being marked as fivetran_deleted. This may because these were soft deleted, rather than hard-deleted. Possibly due to accounting auditing purposes. Maybe we want to filter these out in the end models.
Relevant error log or model output
No response
Expected behavior
Don't include values from records that were soft-deleted
dbt Project configurations
n/a
Package versions
0.1.0
What database are you using dbt with?
bigquery
dbt Version
1.0.0
Additional Context
No response
Are you willing to open a PR to help address this issue?