On: Ask HN: Do you use foreign keys in relational data...

[Simon_O_Rourke]

I'd love to have prohibition of using just any old key in a join, but Snowflake, and Redshift to a lesser extent, just don't care.

In fact, Snowflake really really doesn't care to the extent that I've seen non unique primary keys in tables.