Agent skill · data analytics · aradotso
snowflake-dbt-airbnb-analytics
Inside Airbnb data warehouse built with Snowflake and dbt, demonstrating modern analytics engineering patterns with staging, intermediate, and mart layers.
Why this skill is useful
Adds executable scripts for loading and transforming Airbnb data in Snowflake using dbt, which are not commonly found in public documentation.
What it needs
Requires dbt, python3, snowflake-connector-python, streamlit installed locally. Requires snowflake account access. About 8k tokens when loaded. Last updated 2026-08-05. 5 stars on the source repository.
What this skill does
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 Configuration 1. Snowflake Credentials Create local-only credential files (ignored by git): profiles.yml (dbt connection): config/localcredentials.json (Streamlit connection): Use environment variables in production: 2. Download Inside Airbnb Data Place raw files in data/raw/: Recommended dataset: New York City from Inside Airbnb. Loading Raw Data The Python loader creates Snowflake objects and stages data: What it does: 1. Executes setup/snowflakesetup.sql to create database, schemas, and stage 2. Uploads raw files to INSIDEAIRBNBSTAGE 3. Creates raw tables with headers from CSV files 4. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aradotso/snowflake-dbt-airbnb-analytics