From snowflake documentation it seems that there is an ER application that will allow connecting to the dwh to create diagrams - https://www.snowflake.com/blog/support-multiple-data-modeling-approaches-with-snowflake/.
Does anyone know what tool is used in the article? Can you recommend alternative ER tool for modelling purposes?
I will assume that there are several tools that will connect to Snowflake and allow you to edit models of its schemas.
The tool used in the article looks like Oracle SQL Developer Data Modeler.
Look at the Wikipedia chart: Comparison of data modeling tools for alternatives.
Also please remember that constraints in Snowflake (references, indices) are soft - not enforced - but that doesn't matter and works fine with Entity Relationship Modeling.