Snowflake Dbt Airbnb Analytics

A solid reference implementation if you're learning analytics engineering or need a starter template for Snowflake and dbt. It demonstrates the full staging-intermediate-mart layering pattern using Inside Airbnb's open datasets, with incremental models for the fact tables and a basic Streamlit dashboard on top. The code shows practical patterns like using `{{ ref() }}` for dependencies, implementing merge strategies with `unique_key`, and handling Snowflake credentials across dbt profiles and Python scripts. It's more educational scaffold than production-ready project, but that's the point. If you're building your first dbt warehouse or need to show someone what modern data modeling looks like, this covers the fundamentals without getting fancy.

Install to Claude Code

npx -y skills add aradotso/data-skills --skill snowflake-dbt-airbnb-analytics --agent claude-code