How Open Source Enables Innovation A Case Study with dbt and Lightdash
summary
Shows how dbt extends schema YAML with a meta field and how Lightdash reads that metadata to auto-create metrics, dimensions, joins and descriptions; demo uses the dbt Cloud IDE to run SQL models, write tests and push DDL into the warehouse, then Lightdash syncs and visualizes the defined metrics. Community scale is concrete: 19,000-member Slack, ~7,000 companies using dbt and ~2,000 paying customers, and the integration demonstrably works end-to-end.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 2:05What is dbt
- 5:34What is Lightdash
- 8:42Knowledge Sharing
- 13:54Open Source Modifiable Extensible Reusable
- 15:03Open Source Modifiable Extensible
- 15:35Open Source Contributions
- 16:23Open Source Platforms
- 18:45Open Source Development
- 20:09Demo
related talks
49mdbt: A Software Engineering Approach To The Analytics Workflow
23mDelivering Modern Data Stacks With dbt to Operationalise Analytics
19mRobust CI Workflow with dbt for Data Warehouse Optimization
01h 42mFall in Love with Data Transformation: DBT as Your Weapon
49mSilja Märdla | Data Track | Compass AI & Data Summit 2025
24mMake data central feature
39mBuilding a Modern Data Warehouse Without Breaking the Bank
44mData Mesh