We are using S3 Connection to load data to our Lakehouse. We implemented the identity resolution as per documentation here https://help.heap.io/heap-connect/heap-connect-guide/identity-resolution/
What we have noticed is that the user_migrations table always contains only up to 250K rows and as the table strategy for ingestion is not incremental, we are missing on some of the identity resolution for our events and sessions.
Is this expected behaviour and known limitation? We haven’t found anything in the documentations mentioning this. Is there a workaround we could rely on?