Physical modeling
Chapter 1, Unlocking the Power of Modeling separated the many meanings and applications of the word model, noting how it is used for the physical structure of database tables and the accompanying visual diagram. A physical model contains all the information necessary to construct and deploy the design to a specific database (e.g., Snowflake).
This also works in the opposite direction; many modeling tools and SQL integrated development environments (IDEs) can reverse engineer diagrams directly from the database data definition language (DDL). Reverse engineering lets users generate visual representations of the underlying schema on the fly to help them explore relationships.
How exactly does this conversion work?
What it is
The physical model is a blueprint for deploying a database to Snowflake and the map that holds the technical and operational links that help users navigate it.
The transition from logical to physical modeling is largely systematic...