< complete this with the duplicates detection> I can't get ids here because I'm grouping by email, emails are same not ids

hi @Daniel Vérité I think timestamps should be different by a few ms (I updated my question). Is there a way I can verify that they are different before I commit to this solution?

was my update helpful? should I use different set of indexes?

I grabbed old staging schema instead of the latest prod schema. It's updated correctly now. My apologies

@RickJames I grabbed old staging schema instead of the latest prod schema. It's updated correctly now

also added more context on how we actually query the data

I updated question with create table statement. I don't have any text columns in that table, but there is anywhere between 11-20 million records living in that table for 45 days and they slowly die (TTL expires) of and are populated with another set of events that are there for 45 days. Sometimes there are more or less, but it's a big table, and we do filtering on top for troubleshooting purposes.