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

Performance considerations and monitoring

Because the Snowflake services layer takes care of query tuning and optimization, writing efficient queries and following best practices should be the developer’s only concern. To do this, Snowflake provides a visual query profile to break down query execution into constituent substeps and help identify potential issues. A sample query profile can be seen in the following screenshot:

Figure 13.10: Snowflake query profile

A good way to familiarize yourself with the query profile screen is by reviewing the kinds of query issues that it is designed to identify. The numbers in the query profile correspond to the topics listed in the following section.

Common query problems

Most day-to-day query issues can be identified by paying attention to the information displayed in the query profile and following the query best practices described here: