I hope this message finds you well. I am currently working with a dataset that has been constructed using the SalesLeads table, Sales table, and SalesAttribution table from a Postgres database. The SalesAttribution table essentially establishes the relationship between SalesLeads and Sales, determining whether a Sale should be attributed to a specific Sales Lead.
In order to keep the dataset up to date, I have configured an incremental refresh on a daily basis with a window size of 1 day. This approach is intended to capture all the updates that have taken place during the previous day.
However, I am encountering an issue where the dataset is not being fully updated with the inclusion of new records. This comprehensive update seems to occur only when I manually initiate a Full refresh.
I appreciate any insights or guidance you can provide to help me resolve this matter effectively.
Thank you for your assistance.
ClosedAt is a DateTime column in the SalesLeads table
Was this the incremental refresh working as expected prior to this or was this your first time using it? Also, what is the frequency that you set for the refresh before you chose the window size?
If you are still running into this error I would suggest creating an AWS support ticket.
Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf.
