Raw clickstream lands in object storage and somehow becomes clean tables, dashboards, and ML features. The design questions are table format, the bronze-silver-gold layering, batch versus streaming, and how you handle schema drift and late data. Here is the lakehouse blueprint.
← System Design for AI in Production / 104
Design a data lakehouse pipeline that ingests raw events and serves both analytics and ML features.
Raw clickstream lands in object storage and somehow becomes clean tables, dashboards, and ML features. The design questions are table format, the bronze-silver-gold layering, batch versus streaming, and how you handle schema drift and late data. Here is the lakehouse blueprint.
Updated Aug 2026 · Grounded in real Applied AI Engineer interview loops and written to a senior-engineer editorial bar.
Unlock the other 754 answers · ₹2,000 / $25includes both full courses · progress stays saved · 6 months · one payment · no auto-renew
LEARN THE BACKGROUND
No lesson covers this question directly yet. These teach the surrounding topic from the beginning.
Applied AI Engineering·The interviewPremium14mDriving the design conversationA design round is a conversation you are expected to lead, not a question you answer. This lesson is the shape that works, the four moments that decide the outcome, and the two classic ways strong candidates lose one.Applied AI Engineering·The interviewPremium12mTurning this course into a study planA concrete four-week plan mapping the seven modules onto the question bank, plus what to do differently if your interview is next week rather than next month.
UP NEXT ON YOUR JOURNEY
Next in this trackDesign a large-scale web crawler that fetches billions of pages while being polite and avoiding traps.Next in this trackDesign a real-time leaderboard that ranks millions of players and updates scores instantly.Next in this trackDesign a geo-proximity service that finds the nearest places to a user, like Yelp or store locators.
DISCUSSION · 0
No comments yet — be the first to share your approach.
