This message was deleted.

Off the top of my head, MSQ sounds like the best way (as you describe). If there's a native way, I'm sure someone else will chime in.

This blog describes some options: https://imply.io/blog/upserts-and-data-deduplication-with-druid/

Thank you Sergio. Will check it out.