From the course: Data Engineering with dbt
Join today to access over 24,700 courses taught by industry experts.
Materialization in your dbt project - Data Build Tool (dbt) Tutorial
From the course: Data Engineering with dbt
Materialization in your dbt project
- [Instructor] So we've created our DBT models, but there's one small thing we need to consider is that how do we want the models to look like for our database users. Within DBT, it's called Materialization and Materialization essentially controls how your models within your database are viewed and created. Why you may want to do this is you want to limit what tables can be viewed by your database users. Maybe you want to reduce the cost of data storage by not having them materialized, but still available. Or you may want to speed up certain data pipelines such as a dashboard so it doesn't have to wait for the query to run before you can actually get the data. DBT allows five different materialization methods table, view, incremental, ephemeral, and materialized view. But for our project, we're only going to worry about table, which places the data within the database view, which pulls the data only after you reference it. And…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
