Questions? 1-844-766-9355

Gartner Data Lake


Get Your Complimentary Copy

Convert Schema-on-Read into

Businesses that employ the Schema-on-Write methodology know the importance of data modeling. In Schema-on-Write, a data modeler or database designer creates a structure, or “schema,” for the data before it is loaded, or “written,” into the system. 

With the more recent advent of the Schema-on-Read methodology, in which the goal is to load data into the system as quickly as possible and without upfront design and modeling, data modeling has taken a backseat. Still, it remains no less important: Data modeling helps define the structure and semantics of data, so business users and data scientists can properly query, manipulate, and analyze it. 

Schema-on-Read requires that data be transformed into an understandable relational model in order to allow business users to make sense of it. As it turns out, semi-structured data can be transformed into a relational model by applying data modeling best practices. Download our eBook "Data Modeling in the Age of JSON" and learn how to:

Transform JSON data into traditional relational models

Turn JSON into three form factor (3NF) and a Data Vault model

Handle document changes in Schema-on-Read, and more...

Learn How to Get the Most
Out of Your Data

This complimentary dummies guide explains the cloud data warehouse and how it compares to other data platforms.

Follow us

Privacy Notice | Site Terms

© 2020 Snowflake Inc. All Rights Reserved

450 Concar Drive, San Mateo, CA, 94402, United States | 844-SNOWFLK (844-766-9355)