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

2. Unlocking the Power of Modeling FREE CHAPTER

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

Iceberg tables

Snowflake Iceberg tables seamlessly integrate the Apache Iceberg Open Table Format (OTF) within the Snowflake cloud platform. This integration enhances data management capabilities by providing robust features such as Atomic Consistent Isolated Durable (ACID) transactions, schema evolution, and time travel for externally stored and accessible files. As a result, Snowflake Iceberg tables deliver efficient query performance comparable to standard tables, ensuring consistent and scalable data operations. They also facilitate interoperability across multiple processing engines and cloud platforms, making them ideal for managing large and evolving datasets without vendor lock-in.

Open table formats explained

OTFs are open source logical tables designed to work with tabular data stored in existing file formats such as ORC and Parquet. In addition to the columnar data itself, OTFs store metadata (i.e., partition statistics and operational logs) in a separate file or...