data-warehousing

Name: data-warehousing
Availability: InStock
Author: AbsolutelySkilled

Design dimensional data warehouse models with surrogate keys and SCD Type 2 for Snowflake and BigQuery.

207|31|Updated Mar 14, 2026

Search Tags:#partitioning #bigquery #snowflake #dimensional-modeling #star-schema #data-warehousing #scd

Ready to run

npx skills add https://github.com/AbsolutelySkilled/AbsolutelySkilled --skill data-warehousing-absolutelyskilled

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: data-warehousing
Source: https://github.com/AbsolutelySkilled/AbsolutelySkilled/tree/main/skills/data-warehousing
Command: npx skills add https://github.com/AbsolutelySkilled/AbsolutelySkilled --skill data-warehousing-absolutelyskilled

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Data teams need a production-grade framework to design, build, and optimize analytical data warehouses using dimensional modeling, SCD patterns, and platform-specific guidance for Snowflake and BigQuery.

Core Features & Use Cases

End-to-end guidance on star and snowflake schemas, surrogate keys, grain declaration, partitioning, and clustering.
Platform-specific best practices for Snowflake and BigQuery, including performance optimizations and cost controls.
Practical, ready-to-adapt SQL patterns and design choices for analytics teams to implement in real projects.

Quick Start

Design a dimensional model for analytics with explicit grain, conformed dimensions, and SCD Type 2 history for a representative 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 star schema with surrogate keys and explicit grain for analytics?▼

Implement SCD Type 2 by adding surrogate keys, effective start and end dates, and a current record flag to dimension tables. This pattern preserves historical attribute changes for accurate point-in-time analytics in your data warehouse.

What are the best practices for partitioning and clustering in BigQuery and Snowflake?▼

Best practices for partitioning and clustering in BigQuery and Snowflake involve selecting high-cardinality columns for clustering and time-based columns for partitioning. This reduces scanned data volumes, lowering costs and accelerating analytical query performance.

How do I implement SCD Type 2 history tracking for time-variant dimensional data?▼

Does this dimensional modeling approach work for both Snowflake and BigQuery projects?▼

Yes, this dimensional modeling approach applies to both Snowflake and BigQuery projects. It provides platform-specific guidance for performance optimizations, cost controls, partitioning, and clustering to ensure production-grade correctness.

When should I use a snowflake schema instead of a star schema in my data warehouse?▼

Use a snowflake schema instead of a star schema when normalizing dimensions to reduce redundancy and storage, though star schemas are generally preferred for simpler, faster analytical queries in data warehousing architectures.