Source
Set operators
Set operators combine the intermediate results of multiple query blocks into a single result set.
Estimating Similarity of Two or More Sets
Snowflake uses MinHash for estimating the approximate similarity between two or more data sets. The MinHash scheme compares sets without computing the intersection or union of the sets, which enables efficient and effective estimation.