Data Build Tool - a tool to build data

24/01/2023 39 min Temporada 2023 Episodio 112
Data Build Tool - a tool to build data

Listen "Data Build Tool - a tool to build data"

Episode Synopsis

The guest of our show presented the Data Build Tool, DBT, in one of our knowledge-sharing sessions. Especially the fun part is what I recognize when I look at this knowledge-sharing session. The guest of the show presented it in an enthusiastic way and used terms like: the macro functionality makes DBT awesome and Ephemeral is the Unique Selling Point. What this episode coversIn GeneralWhat is a Data Build Tool?What problems does it solve?What are the two versions? Cloud, CLIWhy is it much more interesting to use than other ETL, transformation tools?Analytics EngineeringExplain a bit more in debt the Basics of a DBT project: dbt project data pipeline, data model, tests, macros.Model dependenciesDBT-packages ecosystemOne of the powers of DBT is Jinja.What could you compare Jinja to?Is it easy to comprehend and learn?Ephemeral (CTE) was the unique selling point for you, why?An engineer enthusiastic about a documentation feature… that asks for an explanation.Within bol.comUsage started as an experiment, how are we using it in bol.com?Can you share some learnings you and your team had when you started using DBT?GuestsSander Boumeester – Software Engineer in the experimentation team.NotesOn the website of getdbt there's a cool picture that explains the framework really well.