Eli Sander

@dbeatty10 that is truly bizarre; I used your example and replicated the same issue I reported. The only differences between your test and my replication of your test: * My...

@dbeatty10 Really bizarre-- I tried your version, using all of the same files and commands, and I got the behavior you did, where it's correctly updating the table with new...

Ok @dbeatty10, I spent some time trying to reproduce the issue. I was able to reproduce the issue with the following changes: dual.sql ``` {{ config(schema="cohort_self_storage", materialized="table") }} select 'X'...

Yeah, I reran it today, with the same setup as before, and I couldn't reproduce it, either. I'm really at a loss. It was on the same commit where I'd...

I think my next step will be to see if others on my team can reproduce the issue as well from my original setup, to figure out if it's something...

Makes sense to me. I've spent some time working with folks on my end, and although we see the behavior sometimes, it has been difficult to track down a reproducible...

I also experienced this issue. Steps to replicate: 1. Create a table with no duplicates on the unique key (which we'll call `unique_id`) 2. Snapshot the table with `check_cols='all'` 3....

The only thing I'll add here is that I was able to replicate this issue (though intermittently) with a small test table. So it may be easier to see this...