Creating an ERD from a physical model
As we just demonstrated through the forward engineering deployment process, a physical database model is a one-to-one representation of its relational diagram. This implies that the process of generating a diagram can be run in reverse—from Snowflake DDL to a modeling tool—a process known as reverse engineering. Again, it’s not strictly necessary to use dedicated modeling tools such as SqlDBM—many SQL IDEs such as Visual Studio Code and DBeaver can generate Entity-Relationship Diagrams (ERDs)—doing so will offer greater flexibility in organizing, navigating, and making adjustments to your model.
A similar diagram to the one created in the previous exercise can be generated by connecting to our deployed model through a SQL IDE:
Figure 12.4: Reverse engineering in DBeaver IDE
Quick tip: Need to see a high-resolution version of this image? Open this book in the next-gen Packt Reader or view...
