Constrains other than NOT NULL are not enforced, so a primary key is informational and don't enforces uniqueness on primary key fields, that'S why you already can add records whose pk exists already in the table. https://docs.snowflake.com/en/user-guide/table-considerations#label-table-considerations-referential-integrity-constraints