Two Lenses, One Landscape: Bridging the Gap Between ERD and DAG - dbt & SqlDBM скачать в хорошем качестве

Two Lenses, One Landscape: Bridging the Gap Between ERD and DAG - dbt & SqlDBM

Modern Data Modeling in Production: Bridging ERDs and dbt DAGs Featuring Serge Gershkovich (SqlDBM) and Stephan Durry (dbt Labs) Modern data teams are managing increasingly complex environments across cloud data platforms, transformation frameworks, and analytics workflows. In this session, experts from SqlDBM and dbt Labs walk through practical strategies for aligning relational data modeling (ERDs) with transformation workflows (dbt DAGs) to support scalable, production-ready data architectures. What’s covered in this webinar 00:00 – Welcome & introductions Overview of the session and the challenge modern data teams face when aligning relational modeling with transformation workflows. 03:10 – Why modern data modeling is getting harder Discussion of how the modern data stack, cloud platforms, and distributed teams have increased complexity in designing and maintaining data models. 07:25 – ERDs vs DAGs: Two lenses on the same data system How relational data models (ERDs) and transformation pipelines (dbt DAGs) represent different but complementary perspectives of the same data architecture. 12:40 – Where modeling and transformation workflows break down Common challenges teams encounter when trying to align architecture design with production transformation pipelines. 17:30 – Best practices for structuring scalable data models Practical strategies for designing models that remain maintainable as data platforms and teams scale. 24:10 – Synchronizing relational modeling with dbt workflows How modern data teams keep architecture, documentation, and transformation logic aligned across tools. 31:50 – Live demo: Importing dbt manifests into SqlDBM Walkthrough showing how dbt project metadata can be visualized and managed in SqlDBM using the dbt manifest upload feature. 40:20 – Visualizing data models alongside dbt transformations How visual modeling improves collaboration between data architects, analytics engineers, and platform teams. 46:10 – Preview: dbt Fusion (next-generation dbt engine) Sneak peek at upcoming dbt capabilities and how they will impact modern data workflows. 50:40 – Q&A and closing discussion Audience questions and discussion around best practices for modern data modeling. Who this webinar is for: Data architects Analytics engineers Data engineers Platform teams working with dbt and modern cloud data platforms