https://community.snowflake.com/s/article/COUNT-DISTINCT-and-NULLs
To count multiple distinct columns where null is not a value in any of the columns:
SELECT COUNT (DISTINCT COL1, COL2) FROM T1;
Otherwise
SELECT COUNT(*) FROM (SELECT DISTINCT COL1, COL2 FROM T1);