Data Modeling for Snowflake with SqlDBM ft. Kent Graziano & Serge Gershkovich скачать в хорошем качестве

Data Modeling for Snowflake with SqlDBM ft. Kent Graziano & Serge Gershkovich

How do you keep track of all the tables created in your Snowflake databases? What about their relationships and data lineage from staging to reporting? Data modeling has been helping answer these questions for as long as there have been relational databases, and it continues to evolve through cloud-native functionality that enables instant collaboration, real-time sharing, git integration, and more! In this webinar, Serge Gershkovich - data architect and Snowflake Data Superhero, and The Data Warrior, Kent Graziano - industry expert, writer, and thought leader, will discuss the role that data modeling plays in modern cloud data platforms like Snowflake - supporting enterprise teams from engineering, to data science, to governance. We hope you'll join us for this session as we go hands-on to demonstrate how modeling - in an intuitive, web-based approach - can benefit all users as an asset in a data platform instead of a project liability. We will dive into modeling Snowflake-specific features like views, procedures, and functions and explore broader applications like Data Vault and Data Mesh. TIMESTAMPS 00:00 Intro 02:03 SqlDBM and Snowflake, a history 5:39 The value of data modeling 12:53 The discipline of modeling data 17:25 Introducing a data modeling practice 22:38 Demo: 0 to Snowflake 28:50 Demo: eliminating technical debt with Suggested Relationships 34:26 Demo: how cloud enables collaboration 36:21 Demo: Dedicated Snowflake-specific properties and data types 39:30 Demo: living documentation and cataloging 42:30 Demo: from relational models to data pipelines 45:40 Demo: column view lineage 49:20 Audience Q&A