You're reading from Data Modeling with Snowflake A practical guide to accelerating Snowflake development using universal modeling techniques

Product type Paperback

Published in Sep 2025

Publisher Packt

ISBN-13 9781837028030

Length 432 pages

Edition 2nd Edition

Tools

Snowflake

Concepts

Data Engineering

Author (1):

Serge Gershkovich

View More author details

Table of Contents (28) Chapters

Preface

1. Core Concepts in Data Modeling and Snowflake Architecture FREE CHAPTER

2. Unlocking the Power of Modeling

3. An Introduction to the Four Modeling Types

4. Mastering Snowflake’s Architecture

5. Mastering Basic Snowflake Objects

6. From Logical Concepts to Snowflake Objects

7. Mastering Advanced Snowflake Objects

8. Seeing Snowflake’s Architecture Through Modeling Notation

9. Applied Modeling from Idea to Deployment

10. Putting Conceptual Modeling into Practice

11. Putting Logical Modeling into Practice

12. Database Normalization

13. Database Naming and Structure

14. Putting Physical Modeling into Practice

15. Solving Real-World Problems with Transformational Modeling

16. Putting Transformational Modeling into Practice

17. Modeling Slowly Changing Dimensions

18. Modeling Facts for Rapid Analysis

19. Modeling Semi-Structured Data

20. Modeling Hierarchies

21. Data Modeling for Enterprise Teams

22. Scaling Data Models through Modern Techniques

23. Unlocking Value for Enterprise Organizations

24. Unlock Your Exclusive Benefits

Unlock this Book’s Free Benefits in 3 Easy Steps

25. Other Books You May Enjoy

26. Index

Appendix

Solving Real-World Problems with Transformational Modeling

This part focuses on advanced transformational modeling techniques and covers the theory and practice of putting them into action in Snowflake. First, we explore slowly changing dimensions—critical for maintaining historical data accuracy and ensuring consistency across different versions of data. Then, we learn how to model facts for rapid analysis, including best practices for optimizing query performance. We then explore semi-structured data formats and hierarchies, which are becoming increasingly prevalent and which Snowflake is so adept at handling.

This part has the following chapters: