skills.rest
AbsolutelySkilled
AbsolutelySkilledOFFICIAL
Explore all skills by this author →
GitHub

data-warehousing

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
One-click install
npx skills add https://github.com/AbsolutelySkilled/AbsolutelySkilled --skill data-warehousing-absolutelyskilled
Or copy as Structured Prompt for Agent▼
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?▼

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.

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.

Related Skills

Explore More Data & Analytics Skills→
nrakownrakow
1

staging-layer

Convert raw source tables into standardized dbt staging models with 1:1 mapping.

Community
Intermediate
guygrigsbyguygrigsby

olap-schema-design

Design OLAP star schemas with surrogate keys and SCD Type 2 tracking.

Community
Advanced
pluginagentmarketplacepluginagentmarketplace
5

data-warehousing

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

Community
Intermediate
snoodleboot-iosnoodleboot-io
2

dimensional-modeling-minimal

Explain dimensional modeling concepts with star schema SQL examples.

Official
Intermediate