News for hackers. Stuff that matters.

A comment on Show HN: Data Diff – compare tables of any size across databases. Parent comment

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....

[ Parent | on HN ]
Re:Show HN: Data Diff – compare tables of any size across da... by snidane on Thursday June 23, 2022 @12:36AM (#31845198)
Snowflake doesn't support this kind of except, which is needed for the diff to work seamlessly:

  select * except (column1, column2, ...)
[ Parent | on HN ]