ETL vs ELT

Problem

Your team is migrating data pipelines from a legacy server to a modern cloud data warehouse (e.g. Snowflake). Instead of transforming data in-memory before loading it, you load raw files directly and run transformations using SQL. Write a query that outputs explanation with the value: "ELT loads raw data directly into the target system and performs transformations using the target database engine, scaling better than legacy ETL servers."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution