Snowflake primary keys woes
In my work I have used Snowflake quite a lot. The so called Data Cloud is very popular. Getting started is easy.One of the issues I have with Snowflake, it’s lacking primary keys! When you insert data, there’s no way to guarantee that data isn’t duplicated. Of course, Snowflake being SQL compatible you can add some primary key constraints, but they’re mostly ignored.This should square any data engineer, architect or analyst away – but yet people just seem to accept. Solutions for the problem, as it always gets a problem sooner later I have seen: What amazes me, everyone has the above problem. But rather then deciding that Snowflake might not be the best tool for the job, people start doubling-down on Snowflake. Maybe because it costs so much per month. Or because all the tooling you have to invest time in just to get it working reliable.