Grokking the Data Engineering Interview
Vote

0% completed

​

ETL and ELT

A utility's smart electricity meters report how much energy each home used in every 15-minute slot, and the billing team needs one total per meter per day. This lesson builds that pipeline twice. The first version cleans and totals the readings on its own server and then loads only the daily totals into the warehouse. The second version loads every reading unchanged and computes the same totals inside the warehouse with SQL.

On the first day, both versions produce the same table

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content