Data Data Warehouse

Use when the user asks about a data warehouse on Snowflake, BigQuery or Redshift, clustering and partitioning, materialized views, OLAP performance or warehouse cost. Produces platform-specific table design and optimization steps. Not for Kimball grain and SCD design (use data-dimensional-modeling) or pipeline orchestration (use data-etl-pipeline).

45 stars 6 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add j4flmao/agent-skills --skill data-data-warehouse
Manual install
git clone --depth 1 https://github.com/j4flmao/agent-skills.git /tmp/agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/agent-skills/skills/data/data-warehouse ~/.claude/skills/data-data-warehouse

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Data Data Warehouse

## Purpose
Design data warehouse schemas with dimensional modeling, platform-specific optimization, materialized views, and cost controls.

## Agent Protocol

### Trigger
Exact user phrases: "data warehouse", "Snowflake", "BigQuery", "Redshift", "star schema", "snowflake schema", "OLAP", "dimensional modeling", "fact table", "dimension table", "data warehouse design", "warehouse schema", "partition", "cluster", "materialized view", "warehouse optimization", "slowly changing dimension".

### Input Context
Before activating, verify:
- Warehouse platform (Snowflake, BigQuery, Redshift, DuckDB)
- Data size and growth rate (TB scale, daily increment)
- Query patterns (dashboard, ad-hoc, ML feature extraction)
- Business domains (sales, marketing, finance, product)
- Compliance requirements (data retention, PII masking)

### Output Artifact
Data warehouse design with schema, partition strategy, optimization plan as SQL and YAML.

### Response Format
```sql
-- Fact table DDL
-- Dimension table DDL
-- Materialized view DDL
```
```yaml
# Partition/cluster config
# Cost optimization rules
```

No preamble. No postamble. No explanations. No filler/hedging/transitions. Compress output — why use many token when few do trick.

### Completion Criteria
- [ ] Dimensional model with fact and dimension tables designed
- [ ] Slowly changing dimension strategy selected (SCD Type 2 default)
- [ ] Partitioning and clustering configured per table
Read the full skill on GitHub

Details

Skill name
data-data-warehouse
Path
skills/data/data-warehouse/SKILL.md
License
MIT
Repo updated
17 November 2026

FAQ

What does the Data Data Warehouse skill do?

Use when the user asks about a data warehouse on Snowflake, BigQuery or Redshift, clustering and partitioning, materialized views, OLAP performance or warehouse cost. Produces platform-specific table design and optimization steps. Not for Kimball grain and SCD design (use data-dimensional-modeling) or pipeline orchestration (use data-etl-pipeline).

How do I install the Data Data Warehouse skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add j4flmao/agent-skills --skill data-data-warehouse. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Data Data Warehouse popular?

It lives in j4flmao/agent-skills, which has 45 GitHub stars and 6 forks.

Related skills

Agent Observability

45

j4flmao/agent-skills

Use when the user asks about agent observability, tracing agent reasoning, debugging an agent loop, OpenTelemetry GenAI spans for LLM calls, LLM cost tracking per agent, agent audit logs or hallucination/eval monitoring in production. Produces instrumentation config, trace schema, dashboards, alerts and cost attribution. Not for generic service tracing without LLMs (use devops-opentelemetry).

DevOps & Cloud

AI Agent Architectures

45

j4flmao/agent-skills

Use when the user asks to build an AI agent, design an agent that calls tools and keeps memory, write an agent system prompt or pick an agent framework (Claude Agent SDK, OpenAI Agents SDK, LangGraph). Produces an architecture brief covering loop, tools, memory, guardrails and evals, routing depth to child skills. Not for workflow patterns (use ai-agentic-workflows).

AI, LLMs & Agents

AI Agent Core Loop

45

j4flmao/agent-skills

Use when the user asks about the agent loop, ReAct vs plan-and-solve, re-planning, Reflexion, an agent stuck in a loop, max iterations or termination conditions. Produces a loop spec or patch with state, success predicate, caps and no-progress detection. Not for overall agent design (use ai-agent-architectures) or tool schemas (use tool-calling-principles).

AI, LLMs & Agents

Data Distributed Compute

45

j4flmao/agent-skills

Use when the user asks about Spark vs Dask vs Ray, Spark executor sizing, shuffle and skew, YARN or Kubernetes resource management, data locality or speculative execution. Produces engine choice, cluster topology and tuning settings. Not for Hive/Spark SQL query tuning (use data-batch-processing) or GPU training (use distributed-training).

Databases

Data Cost Optimization

45

j4flmao/agent-skills

Use when the user asks to cut Snowflake credits, BigQuery slot or on-demand costs, Databricks DBUs, S3 storage tiering or query cost for data workloads. Produces a cost analysis with warehouse sizing, reservations, lifecycle rules and query fixes. Not for overall cloud FinOps (use devops-finops).

Databases

Data Distributed Storage

45

j4flmao/agent-skills

Use when the user asks about HDFS, S3, ADLS, GCS, MinIO or Ceph for data workloads, replication and erasure coding, small-file problems, storage tiering or lifecycle policies. Produces storage backend choice, layout and durability and cost settings. Not for database storage engines (use database-internals-mechanics) or file formats (use data-formats).

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.