Few user_id data is missing in output table from lookup.
In output table i am doing left join with lookup table, but in output few data from lookup is missing.
I had checked the user_id in api playground of lookup its data is there but not available in output.
eg output table has following columns
- uid
- name
lookup table
- uid
- price
after left join lookup to output on uid using latest and after 1mins delay
- output.uid
- output.name
- lookup.price
here for few uid's the price data is null, but if i use same uid to check in api playground of lookup table its price is there. Do anyone know how to resolve this issue, or came across such issue.
Thanks
-
The behavior you are describing is possible when there is a delay or a time window defined on the lookup table. meaning that the data in the lookup table may yet or already not fit into the tie window, hence it will not appear in the joins. So basically while the data does appear in the lookup table, it just doesn't match your join time criteria.
1
Please sign in to leave a comment.
Comments
1 comment