Introduction to Data Modeling

Introduction to Data Modeling in Snowflake

Nuno Rocha

Director of Engineering

Your instructors

Nuno Rocha

Director of Engineering

Picture of Nuno Rocha

Margarita Torres

Senior Data Engineer

Picture of Margarita Torres

Closet, before stage

Closet, after stage

Blueprint of a shopping center

Shopping center, stores overview

Shopping center, circle stores as entities

Shopping center, entities pointing to their attributes

Shopping center, entities with stairways representing relationship

Entity: Object or concept represented in a data model Groceries entity

DESC TABLE: SQL command to display a table's structure

DESC TABLE groceries;

Describe table result

Attribute: Characteristics of an entity Attributes from table

View of e-commerce online retail table rows

Data model: A representation that outlines the organization and storage of data
Entity: Object or concept represented in a data model
Attribute: Characteristics of an entity
Relationship: Connections between entities
DESC TABLE: SQL command to display a table's structure

DESC TABLE table_name;

Introduction to Data Modeling in Snowflake