Skip to main content
affpapa.org
RU EN
skill CX Codex

snowflake-dbt-airbnb-analytics — Claude Code skill: setup guide

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add reason-machines/data-skills --skill snowflake-dbt-airbnb-analytics -a claude-code
Open on GitHub

What snowflake-dbt-airbnb-analytics 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.

What it helps with

  • 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 for the agent

  • 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

How to install snowflake-dbt-airbnb-analytics

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill snowflake-dbt-airbnb-analytics -a claude-code

2Manually: put the files in place

~/.claude/skills/snowflake-dbt-airbnb-analytics/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/snowflake-dbt-airbnb-analytics/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about snowflake-dbt-airbnb-analytics

How do I install snowflake-dbt-airbnb-analytics in Claude Code?

Run npx skills add reason-machines/data-skills --skill snowflake-dbt-airbnb-analytics -a claude-code in your terminal. You can also point your assistant directly to ~/.claude/skills/snowflake-dbt-airbnb-analytics/SKILL.md.

What is snowflake-dbt-airbnb-analytics used for?

It provides structured prompt guidelines for setting up an analytics engineering repository that ingests, models, and tests Inside Airbnb records inside Snowflake with dbt.

Which source files must be downloaded before running transformations?

The pipeline expects listings.csv.gz, calendar.csv.gz, reviews.csv.gz, and neighbourhoods.csv placed inside the data/raw/ directory.

Similar skills

All skills for Data and databases →
xlsx official anthropics Creates, reads, edits, and converts spreadsheet files. Use it when the requested deliverable is an Excel workbook or another tabular file. 187,223installs google-agents-cli-observability official Google This skill guides you through tracing and monitoring AI agents, including ADK agents. Use it when you need to inspect agent execution or monitor a deployed agent. CX Codex +1 511,300installs caveman-evidence-review JuliusBrussee A read-only skill reviews Caveman Cloud evidence on LLM spend, traces, and routing. Use it to see where a project’s model budget goes. CX Codex +1 104,500installs migration JuliusBrussee Enforces reversible, compatibility-safe transitions for schema, data, and API updates. Useful whenever data loss or rollout downtime is unacceptable. CX Codex +1 103,900installs performance-optimization addyosmani An agent skill that measures before it changes code: Core Web Vitals budgets, N+1 queries, missing indexes and slow endpoints. CX Codex +1 65,200installs supabase official supabase Guides the agent through database configuration and strict RLS policies in Supabase. CX Codex GP ChatGPT 8installs

From the same set62

harvard-artifacts-data-pipeline A skill that walks your agent from Harvard Art Museums API extraction to a Streamlit dashboard backed by SQL analytics. CX Codex +1 1,800installs iac-data-engineering-terraform A skill with ready Terraform patterns for data engineering: S3 buckets, EC2 instances and IAM roles. Useful when you need to stand up pipeline infrastructure declaratively. CX Codex +1 1,800installs terraform-iac-data-engineering Teaches your coding agent to scaffold AWS data engineering setups with Terraform. Covers S3 data lakes, EC2 compute instances, and IAM security policies. CX Codex +1 1,800installs terraform-data-engineering-infrastructure A skill with Terraform patterns for data engineering: S3 data lake buckets, EC2 processing nodes, IAM roles. Useful when AWS infrastructure has to be described in code, not clicked together. CX Codex +1 1,800installs harvard-artifacts-etl-pipeline A skill that walks your coding agent through an ETL pipeline from the Harvard Art Museums API to Streamlit charts. CX Codex +1 1,700installs infrastructure-cicd-data-engineering This skill guides Terraform delivery for data infrastructure through GitHub Actions and AWS OIDC. Use it when infrastructure changes need checks, approvals, and automated deployment. CX Codex +1 1,600installs harvard-artifacts-collection-analytics-app This skill guides an ETL workflow and a Streamlit dashboard for Harvard Art Museums data. Use it when a Python and SQL analytics project needs API ingestion. CX Codex +1 1,400installs data-analytics-skills-claude A collection of analytics skills for checking data, investigating metrics, and shaping dashboard specs. Use it when an analysis needs a clear workflow and shareable results. CX Codex +1 1,300installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor