Hi,
I see that some rows are missing with an incremental refresh of DynamoDB data. The issue goes away with Direct Query or Manual Refresh. The missing data are those values which have been calculated after a join of tables. Could you please help us out with this. The dashboard has lot of missing data. I found some similar posts on this - Join misses some matches - #5 by deepika and Data is missing in SPICE dataset
Any help would be appreciated. Thanks!
@deepika, please share more details about your use case scenario in which you are noticing the missing data issue -
1/ Are you missing the data rows from SPICE data set or those rows are not reflecting the most up to date values after incremental refresh
2/ If data rows are not reflecting the most up to date values, is this occurring within the defined lookback window or outside the lookback window
3/if the data rows are missing after joining tables, can you review join condition to confirm if the join is not the root cause for missing data
Please share these details to understand the issue and find appropriate solution.
Thanks
Deepak
Hey @deepika
We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 7 days, we will archive the question.