{"repo":"analyticsdurgesh/Snowflake_DBT_Project","free":true,"listed":false,"github":"https://github.com/analyticsdurgesh/Snowflake_DBT_Project","clone":"git clone https://github.com/analyticsdurgesh/Snowflake_DBT_Project.git","description":"Public Snowflake and dbt analytics engineering project for Inside Airbnb data, marts, tests, docs, and Streamlit dashboard.","language":"Python","stars":23,"topics":["analytics-engineering","data-warehouse","dbt","inside-airbnb","snowflake","streamlit"],"license":null,"category":"data-pipelines","readme_excerpt":"Airbnb Snowflake dbt Analytics Project Public analytics engineering portfolio project that loads the Inside Airbnb open dataset into Snowflake, transforms it with dbt, validates data quality, and powers a Streamlit reporting dashboard. What This Project Demonstrates - Snowflake raw-zone setup for open data ingestion - Local CSV/GZIP loading into Snowflake internal stages - dbt staging, intermediate, and mart model layers - Incremental fact modeling with Snowflake merge strategy - dbt generic tests and singular tests for data quality - Model documentation with persisted docs support - Streamlit dashboard connected to analytics marts - Public-safe configuration with ignored local credential files Dataset Source: Inside Airbnb Recommended classroom dataset: New York City, New York, United States. Expected raw files: Inside Airbnb does not provide booking transactions. This project uses calendar availability and price data as a classroom-friendly proxy for unavailable-night revenue. Architecture dbt Lineage dbt Model Layers Layer Models Purpose --- --- --- Sources RAW.LISTINGS , RAW.CALENDAR , RAW.REVIEWS , RAW.NEIGHBOURHOODS Raw files loaded into Snowflake Staging stg airbnb Cleaning, type casting, standard column names Intermediate int airbnb Reusable joins, enrichment, revenue proxy logic Marts dim listings , dim hosts , fct listing calendar , fct reviews Analytics-ready dimensions and facts Aggregates agg listing monthly performance , agg neighbourhood monthly performance Rep","default_branch":null,"files":null,"tree":[],"storefront":"/r/analyticsdurgesh","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/analyticsdurgesh/Snowflake_DBT_Project/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}