Snowflake, Sql, Data Science, Data Engineering, Optimization.
still shows a join between tables Making sure Snowflake can rely on the constraints So why did the constraints between these tables didn’t help Snowflake optimize this join? Turns out you also need to tell Snowflake it can rely on these constraints. To do so: alter table lineitem_10 alter