skills.rest
pluginagentmarketplace
pluginagentmarketplaceCOMMUNITY
Explore all skills by this author →
GitHub

data-warehousing

Design and optimize Snowflake, BigQuery, and Redshift data warehouse architectures.

5|1|Updated Nov 18, 2025
Search Tags:#Snowflake#BigQuery#data warehousing#dimensional modeling#ETL/ELT#SCD Type 2
One-click install
npx skills add https://github.com/pluginagentmarketplace/custom-plugin-data-engineer --skill data-warehousing
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-warehousing
Source: https://github.com/pluginagentmarketplace/custom-plugin-data-engineer/tree/main/skills/data-warehousing
Command: npx skills add https://github.com/pluginagentmarketplace/custom-plugin-data-engineer --skill data-warehousing

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires yaml, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

Data teams face the challenge of designing scalable, high-performance data warehouses and implementing robust dimensional models. This Skill consolidates proven patterns for Snowflake, BigQuery, and Redshift, helping you deliver reliable analytics platforms faster.

Core Features & Use Cases

  • Dimensional Modeling guidance and SCD pattern implementations (Type 2) to maintain historical accuracy.
  • Performance & Cost Best Practices for clustering, partitioning, materialized views, and optimized storage.
  • Use Case: Build a production-grade warehouse for retail analytics with a clear data model and cost-aware ETL/ELT workflows.

Quick Start

Install the skill in Claude Code and invoke it with a task description, for example: data-warehousing - design a scalable star-schema warehouse for an e-commerce dataset.

Frequently Asked Questions about data-warehousing

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a scalable data warehouse architecture for BigQuery or Snowflake?▼

Design a scalable data warehouse by applying dimensional modeling patterns and cost-aware ETL/ELT workflows tailored for BigQuery, Snowflake, and Redshift environments. It provides guidance on building reliable analytics platforms with optimized storage and performance.

What is the best way to implement SCD Type 2 for historical data accuracy in dimensional modeling?▼

Implement SCD Type 2 in dimensional modeling by applying proven patterns to maintain historical accuracy within your data warehouse. This approach supports tracking historical changes in dimension attributes over time for reliable analytics.

How do I optimize data warehouse performance using clustering and partitioning strategies?▼

Optimize data warehouse performance by applying clustering, partitioning, and materialized views based on best practices. This approach ensures cost-aware optimization and efficient query execution across your analytics platform.

Can I use this to build a production-grade retail analytics platform with a star schema?▼

Yes, you can build a production-grade warehouse for retail analytics using a clear star-schema data model. It supports dimensional modeling and cost-aware ETL/ELT workflows to deliver reliable analytics platforms.

Does this support ETL and ELT workflows for modern cloud data warehouses?▼

Yes, it supports both ETL and ELT workflows for modern cloud data warehouses including Snowflake, BigQuery, and Redshift. It consolidates proven patterns to help data teams deliver reliable analytics platforms faster.

When should I use materialized views in my data warehouse design?▼

Use materialized views in data warehouse design to improve query performance and reduce compute costs as part of cost-aware optimization strategies. They are essential for pre-computing complex aggregations in dimensional models.

Related Skills

Explore More Data & Analytics Skills→
snoodleboot-iosnoodleboot-io
2

dimensional-modeling-minimal

Explain dimensional modeling concepts with star schema SQL examples.

Official
Intermediate
modus-bimodus-bi

data-analyst-expert

Analyze BI datasets to generate Level-4 insights with quantified recommendations.

Official
Advanced
timequitytimequity
6

pipeline-design

Design ETL/ELT pipeline architectures for batch and streaming data integration.

Official
Advanced
PrepLabsAIPrepLabsAI
94

schema-design-interviewer

Design and critique data warehouse schemas for analytics interviews.

Official
Advanced