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.

skills.sh installs: 1.2K
GitHub stars: 2
last updated: Jul 14, 2026

View on GitHub

Install

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

Installs into .claude/skills of the current project.

Files

Snowflake dbt Airbnb Analytics

Skill by ara.so — Data Skills collection.

This project demonstrates a complete analytics engineering workflow using Snowflake, dbt, and Streamlit. It loads Inside Airbnb open data into Snowflake, transforms it through a layered dbt architecture (staging → intermediate → marts), validates data quality with tests, and serves insights via a Streamlit dashboard.

What This Project Does

Raw data ingestion: Loads CSV/GZIP files from Inside Airbnb into Snowflake internal stages
Layered transformations: Implements staging (clean/cast), intermediate (joins/enrichment), and mart (dimensions/facts) layers
Incremental modeling: Uses Snowflake merge strategy for fact tables
Data quality: Generic and singular dbt tests validate uniqueness, relationships, and business rules
Analytics dashboard: Streamlit app queries marts for neighbourhood and listing performance

Data sources: listings.csv.gz, calendar.csv.gz, reviews.csv.gz, neighbourhoods.csv from Inside Airbnb