Re:Show HN: Data Diff – compare tables of any size across da...
by erezsh on Thursday June 23, 2022 @02:15AM
(#31845723)
data-diff has several advantages over running the query you wrote here.
- data-diff can compare tables across different databases. Your query is limited to one database.
- For very big tables, your 'select' will time-out. data-diff splits the diff into small segments, so we side-step this issue.
- data-diff supports running in threaded mode, which means it can finish a LOT faster. (especially for cloud databases.)
Re:Show HN: Data Diff – compare tables of any size across da...
by malcolp on Thursday June 23, 2022 @12:34AM
(#31845192)
I think snowflake supports this.
https://docs.snowflake.com/en/sql-reference/operators-query....
Without the stupid default behavior of SQL, this wouldn't be a problem. I'm curious if Data Diff solves this or some other use case.