SKILL.md
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
Installation
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