Dremio Lakehouse Modeling
OfficialDesign performant lakehouse models in Dremio
Data & Analytics#partitioning#data-modeling#iceberg#lakehouse#reflections#medallion-architecture#dremio
Authordeveloper-advocacy-dremio
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps architects and engineers design consistent, performant, and maintainable data models in a Dremio lakehouse so analytics and ML teams can query fresh, accurate data without costly performance surprises.
Core Features & Use Cases
- Medallion guidance: Concrete patterns for Bronze (raw), Silver (clean/conformed), and Gold (consumption) layers and when to materialize as tables versus views.
- Performance tuning: Reflection strategies, partitioning rules, LOCALSORT recommendations, and maintenance schedules (OPTIMIZE, VACUUM).
- Modeling patterns: Dimensional star schema guidance, SCD Type 2 via MERGE, semantic layer organization, and tagging/documentation practices for governance.
Quick Start
Ask the agent to design a medallion-based lakehouse model for my ecommerce events with partitioning, reflections, and SCD handling.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: Dremio Lakehouse Modeling Download link: https://github.com/developer-advocacy-dremio/dremio-skills-bundle/archive/main.zip#dremio-lakehouse-modeling Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.