# snowflake-dbt-airbnb-analytics

Guides coding assistants through building a Snowflake and dbt warehouse on Inside Airbnb datasets, from stage ingestion to Streamlit reporting.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 1700 installs · ★ 5
- Author: reason-machines
- License: LicenseRef-Unknown · policy=link-only · description only; the file stays with the author
- Source: https://github.com/reason-machines/data-skills/tree/HEAD/skills/snowflake-dbt-airbnb-analytics/SKILL.md
- Updated: 2026-10-09
- HTML: https://affpapa.org/en/nevibecode/skills/snowflake-dbt-airbnb-analytics

## What it does

This skill equips agents with a pattern for analytics engineering projects. It organizes the raw data intake by sending Inside Airbnb compressed archives directly into internal Snowflake stages using Python and `setup/snowflake_setup.sql`. The pipeline then copies raw rows straight into dedicated ingestion tables.

Transformation logic follows dbt conventions split across three distinct tiers. The staging step casts datatypes and standardizes column formats. An intermediate layer joins calendars with listings to compute business metrics such as revenue proxies. Finally, dimensional and fact tables live in the marts layer, where fact tables use merge-driven incremental builds.

Without valid Snowflake warehouse credentials in `profiles.yml` and `config/local_credentials.json`, the entire pipeline halts. The ingestion relies strictly on standard Inside Airbnb CSV layouts, so altered schemas will break table builds.

## Requirements
- Works with: Snowflake

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill snowflake-dbt-airbnb-analytics -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/snowflake-dbt-airbnb-analytics/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/snowflake-dbt-airbnb-analytics/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill snowflake-dbt-airbnb-analytics -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/snowflake-dbt-airbnb-analytics/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill snowflake-dbt-airbnb-analytics -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/snowflake-dbt-airbnb-analytics/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install reason-machines/data-skills snowflake-dbt-airbnb-analytics
```

2. **Manually: put the files in place**
- File: `.github/skills/snowflake-dbt-airbnb-analytics/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill snowflake-dbt-airbnb-analytics -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/reason-machines/data-skills --path skills/snowflake-dbt-airbnb-analytics
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/snowflake-dbt-airbnb-analytics/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill snowflake-dbt-airbnb-analytics -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/reason-machines/data-skills/tree/HEAD/skills/snowflake-dbt-airbnb-analytics/SKILL.md

## When to use it
- configure dbt connections for Snowflake warehouses
- establish staging, intermediate, and marts transformation tiers
- process Inside Airbnb raw compressed tables into Snowflake stages
- implement incremental fact models via merge runs
- connect a Streamlit interface to final data marts

## Example prompts
- Set up a dbt Snowflake project using Inside Airbnb data with staging and mart layers
- Create an incremental fact model for the Airbnb calendar dataset
- Configure Snowflake credentials in profiles.yml and write the raw data loader

## Similar
- [snowflake-snowpark-dbt-cursorrules-prompt-file](https://affpapa.org/en/nevibecode/rules/snowflake-snowpark-dbt-cursorrules-prompt-file.md) — rule · ★ 41024
- [snowflake-development](https://affpapa.org/en/nevibecode/skills/snowflake-development.md) — skill · 25 installs
- [dbt-sf-to-bq-translator](https://affpapa.org/en/nevibecode/skills/dbt-sf-to-bq-translator.md) — skill · 2300 installs
- [neo4j-snowflake-graph-analytics-skill](https://affpapa.org/en/nevibecode/skills/neo4j-snowflake-graph-analytics-skill.md) — skill · 752 installs
- [migrating-dbt-project-across-platforms](https://affpapa.org/en/nevibecode/skills/migrating-dbt-project-across-platforms.md) — skill · 526 installs
- [using-dbt-for-analytics-engineering](https://affpapa.org/en/nevibecode/skills/using-dbt-for-analytics-engineering.md) — skill · 1200 installs

From the same set: [reason-machines/data-skills](https://affpapa.org/en/nevibecode/by/reason-machines/data-skills.md) — 74 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md