From the course: Data Engineering: dbt for SQL
Join today to access over 25,400 courses taught by industry experts.
Solution: Materializations
From the course: Data Engineering: dbt for SQL
Solution: Materializations
(bright upbeat music) - [Instructor] Congratulations on completing the materializations challenge. As I mentioned before, there are many correct answers and the solution I present will simply be one of many. Let's navigate to the chapter3 models directory in the UI and open up btc.sql. Next, let's open up the lineage view in the bottom bar. We can see the btc model has a parent which is the crypto data model, and has a single child, which is another model that contains only the btc prices where a closing price is above 3K. Let's take one step up and click on the crypto data model. Once the view is open, lineage view shows us that this model reads from raw crypto data and it also shows a number of other child models, each of which corresponds to a separate coin, btc, eth, link, oxt, xlm, and xrp. Now, let's quickly look at the code for one of these files. Let's just pick btc.sql for ease. Let's take a step back…
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.