From the course: Data Engineering: dbt for SQL

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Challenge: Materializations

Challenge: Materializations

From the course: Data Engineering: dbt for SQL

Start my 1-month free trial Buy for my team

Challenge: Materializations

“

(upbeat music) - [Instructor] Let's put our knowledge about all things materializations to practice and help a fictional version of our crypto company above. Open up Codespaces and navigate to chapter three. You'll see a DBT project has been created for you. This project contains a data set of crypto data over a fixed period of time. It includes data across Bitcoin, Ethereum and a few other coins. To get started run DBT Seed, to seed the raw crypto data table with the necessary information. Once the seed command has successfully run, you should be able to navigate SQL tools, open up the chapter three database, right click on the raw crypto data table and select show table records to see what the data looks like. It's always wise to run some basic exploratory analysis on new data as well. From there, open up the models folder underneath chapter three and use the DBT power user plugin and lineage view to get an…

Contents