Marketplace
Airbnb interview themes
What people report studying for — not a take-home dump. Last editorial update 2026-07-12.
Rounds you should expect
Modeling
One row per booking vs per stay-night. They will ask which metrics break if you pick wrong.
dbt
Incremental lookback for late cancellations. unique + not_null on the booking key.
Recently added questions
2026-07-15 · Late cancellations
Your incremental orders model uses max(updated_at). Cancellations from three days ago never land. Why?
A strict greater-than-max misses late rows. Add a lookback window (or a created_at plus an updates stream) and a unique test on the booking key.
From the question bank
easy · SQL · SQL
Sessionize click events with a 30-minute inactivity gap.
Practice →medium · SQL · SQL
A date spine is missing Sundays. What breaks in a 7-day rolling metric?
Practice →medium · Warehouse · Snowflake
Streams and Tasks vs an external orchestrator. How do you choose?
Practice →hard · Warehouse · Snowflake
Dynamic Tables vs Streams + Tasks. Pick one and defend it.
Practice →medium · Warehouse · Snowflake
A task graph and Airflow both schedule the same MERGE. Failure mode?
Practice →medium · Data modeling · dbt
Incremental model: merge vs delete+insert vs insert_overwrite. Pick one and defend it.
Practice →hard · Data modeling · dbt
Semantic Layer vs copy-pasted Looker measures.
Practice →medium · Data modeling · dbt
You need yesterday’s incremental plus a 3-day lookback for late CDC. How do you not rebuild the month?
Practice →hard · Data modeling · dbt
Two marts both named fct_revenue. How did that happen, and how do you kill one?
Practice →easy · Orchestration · Airflow
Why is catchup=True dangerous on a new DAG?
Practice →easy · Orchestration · Airflow
Sensor versus a shorter schedule. How do you avoid slot deadlock?
Practice →medium · Orchestration · Airflow
Dynamic task mapping vs 12 copy-pasted tasks.
Practice →