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 re

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.