The Book “Data modeling with Snowflake”

By Serge Gershkovich (Author), Kent Graziano (Foreword). 

This book will help you get familiar with simple and practical data modeling frameworks that accelerate agile design and evolve with the project from concept to code.These universal principles have helped guide database design for decades, and this book pairs them with unique Snowflake-native objects and examples like never before — giving you a two-for-one crash course in theory as well as direct application.

Serge

About Serge Gershkovich

Serge Gershkovich is a seasoned data architect with decades of experience designing and maintaining enterprise-scale data warehouse platforms and reporting solutions. He is a leading subject matter expert, speaker, content creator, and Snowflake Data Superhero. Serge earned a bachelor of science degree in information systems from the State University of New York (SUNY) Stony Brook. Throughout his career, Serge has worked in model-driven development from SAP BW/HANA to dashboard design to cost-effective cloud analytics with Snowflake.

He currently serves as product success lead at SqlDBM, an online database modeling tool.

Linkedin

Choose your option

download-2

Chapter 12

Learn about the world of transformational modeling by downloading a free copy
of Ch12.

Download
data-3

Chapter 13

If you want to continue reading, fill out the form below to request chapter 13 access and speak with
an expert.

download-1-1

Find it book on Amazon 

Want to read the full book and take your data modeling to the next level? You can find it in on
Amazon.

Buy online

Reviews

1-1
2-1
3-1
4-1
5-1

Chapter 13 Modeling Slowly Changing Dimensions

In this chapter, Serge reviews eight different SCD structures for meeting various analytical needs: from durable Type 0 attributes that never change to dynamic Type 7 configurations that can handle any requirement. Although many variations exist -even within SCD types-Types 1-3 are the most often used as they strike an acceptable balance between maintainability, performance, and reporting requirements.

Core Insights on SCDs:

  • What SCDs are and their significance.
  • Exploration of the three pivotal types: Type 1 (Overwrite), Type 2 (Add a new row), and Type 3 (Add a new column).
  • Practical recipes tailored for each SCD type.

Benefit from insights on leveraging Snowflake’s materialized views, partitioning features, and change data capture capabilities for optimal SCD handling. Whether you’re new to SCDs or seeking advanced best practices, this Chapter offers a comprehensive roadmap for success in Snowflake.

Request Access & Speak with an Expert

Data Modeling with Snowflake

Eager to elevate your data modeling prowess? If you'd like advice on your data modeling approach.

Book session

Navigating the Evolving Landscape of Data with SCDs

Dims track attributes for business entities that we're interested in but attributes like category and address can change over time learn how (and when) to capture attribute changes with SCDs

We'll explore type 1,2,3. Unravel the complexities of Slowly Changing Dimensions (SCDs) in Chapter 13 of Serge Gershkovich’s ‘Data Modeling with Snowflake’.

Core Insights on SCDs:

  • What SCDs are and their significance.
  • Exploration of the three pivotal types: Type 1 (Overwrite), Type 2 (Add a new row), and Type 3 (Add a new column).
  • Practical recipes tailored for each SCD type.

Benefit from insights on leveraging Snowflake's materialized views, partitioning features, and change data capture capabilities for optimal SCD handling. Whether you're new to SCDs or seeking advanced practices, this chapter offers a comprehensive roadmap for success in Snowflake.

 

Download the Chapter Now

© SqlDBM 2024, Inc. All rights reserved. Privacy Policy 

Help center