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

Product type Paperback

Published in May 2023

Publisher Packt

ISBN-13 9781837634453

Length 324 pages

Edition 1st Edition

Languages

SQL

Tools

Snowflake

Concepts

Data Engineering

Author (1):

Serge Gershkovich

View More author details

Table of Contents (24) Chapters

Preface

1. Part 1: Core Concepts in Data Modeling and Snowflake Architecture

2. Chapter 1: Unlocking the Power of Modeling FREE CHAPTER

3. Chapter 2: An Introduction to the Four Modeling Types

4. Chapter 3: Mastering Snowflake’s Architecture

5. Chapter 4: Mastering Snowflake Objects

6. Chapter 5: Speaking Modeling through Snowflake Objects

7. Chapter 6: Seeing Snowflake’s Architecture through Modeling Notation

8. Part 2: Applied Modeling from Idea to Deployment

9. Chapter 7: Putting Conceptual Modeling into Practice

10. Chapter 8: Putting Logical Modeling into Practice

11. Chapter 9: Database Normalization

12. Chapter 10: Database Naming and Structure

13. Chapter 11: Putting Physical Modeling into Practice

14. Part 3: Solving Real-World Problems with Transformational Modeling

15. Chapter 12: Putting Transformational Modeling into Practice

16. Chapter 13: Modeling Slowly Changing Dimensions

17. Chapter 14: Modeling Facts for Rapid Analysis

18. Chapter 15: Modeling Semi-Structured Data

19. Chapter 16: Modeling Hierarchies

20. Chapter 17: Scaling Data Models through Modern Techniques

21. Index

Why subscribe?

22. Other Books You May Enjoy

Appendix

To get the most out of this book

This book will rely heavily on the design and use of visual modeling diagrams. While a diagram can be drawn by hand, maintained in Excel, or constructed in PowerPoint, a modeling tool with dedicated layouts and functions is recommended. As the exercises in this book will take you from conceptual database-agnostic diagrams to deployable and runnable Snowflake code, a tool that supports Snowflake syntax and can generate deployable DDL is recommended.

This book uses visual examples from SqlDBM, an online database modeling tool that supports Snowflake. A free trial is available on their website here: https://sqldbm.com/Home/.

Another popular online diagramming solution is LucidChart (https://www.lucidchart.com/pages/). Although LucidChart does not support Snowflake as of this writing, it also offers a free tier for designing ER diagrams as well as other models such as Unified Modeling Language (UML) and network diagrams.

Software/hardware covered in the book	Operating system requirements
Snowflake Data Cloud	Windows, macOS, or Linux
SQL	Windows, macOS, or Linux

If you are using the digital version of this book, we advise you to type the code yourself or access the code from the book’s GitHub repository (a link is available in the next section). Doing so will help you avoid any potential errors related to the copying and pasting of code.