-
Notifications
You must be signed in to change notification settings - Fork 115
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[BUG] duplicates in effectivity satelites #231
Comments
Hello! Thanks for this report. If possible can you please edit your post and format your data as tables and code as code snippets using markdown? This would make it easier to read and understand what the issue is. If not we can edit your post for you however this will delay the process. Thanks! |
Hi Alex, |
Thank you. |
Describe the bug
When for two last records in stage for one src_dfk has not been changed src_sfk and between previous and current data processing for this particular src_dfk nothing changed eff_sat always insert one additional record to table.
Environment
dbt version: 1.7.8
automate_dv version: 0.10.2
Database/Platform: postgres
To Reproduce
Steps to reproduce the behavior:
Expected behavior
Records like below should not been added all the time when I run dbt
Additional context
Not sure but I think this is because there is also same load_date for records and in final query partition by and order in this shape is not enough
AB#5346
The text was updated successfully, but these errors were encountered: