dbt vs Stored Procedures (3 key differences)

FREE Modern Data Checklist to give you clarity → https://bit.ly/kds-checklist Project-based training to help you level-up → https://bit.ly/simple-stack Consulting to help you implement → https://bit.ly/kds-consulting ----- When it comes to data transformation, one of the most common tools nowadays is dbt. But one of the arguments against using these code based tools is that you can instead just write store procedures or ad hoc queries directly in the database. While technically this is possible... To me, that misses some of the biggest benefits of using these tools in the first place. And so in this video, we’re going to cover some of the main differences between using code based tools, like dbt (among others). Compared to strictly writing store procedures directly in the database. In particular, we'll talk about differences in core functionality, maintainability and governance. While I recognize these are buzzwordy terms, they're also important. So let's discuss. Enjoy. Timestamps 00:00 - Intro 00:36 - Core Functionality 04:36 - Maintainability 07:40 - Governance & Quality Title & Tags: dbt vs Stored Procedures (3 key differences) #kahandatasolutions #dataengineering #dataarchitecture