What occurs if a foreign key constraint is operating in RELY mode?
For standard Snowflake tables, the RELY property allows the optimizer to assume that the foreign key constraint’s data integrity holds, but Snowflake does not enforce it. The user must maintain the constraint’s referential integrity.
Community Discussion