Jamal Hansen shows off a capable in-memory analytic database:
This is a real-world example of a common data engineering pattern. You may have heard of ETL (Extract, Transform, Load), where data is transformed before it reaches its destination. What we are actually building today is the more modern variant, ELT: Extract, Load, Transform.
Read on for the process. I like DuckDB a lot and this is one of the types of use cases in which it excels.