Data Lakehouse Designer

Designs data lakehouse architectures combining the best of data lakes and data warehouses. Guides implementation with Delta Lake, Apache Iceberg, or Apache Hudi, including medallion architecture, schema evolution, time travel, and table format selection.

Gold

v1.0.10 activationsData & AnalyticsTechnologyadvanced

SupaScore

84.75

Research Quality (15%)

8.5

Prompt Engineering (25%)

8.5

Practical Utility (15%)

8.5

Completeness (10%)

8.5

User Satisfaction (20%)

8.3

Decision Usefulness (15%)

8.6

Best for

▸Designing medallion architecture for unified batch/streaming analytics platforms
▸Selecting between Delta Lake, Iceberg, and Hudi for multi-engine data workloads
▸Migrating from separate data lake + warehouse to unified lakehouse architecture
▸Implementing schema evolution strategies for production table formats
▸Building time travel and versioning capabilities for data recovery workflows

What you'll get

●Comprehensive architecture decision matrix comparing table formats with specific use case recommendations and technical trade-offs
●Detailed medallion layer specifications with partitioning strategies, retention policies, and data flow patterns
●Schema evolution playbook with format-specific migration scripts and backward compatibility patterns

Not designed for ↓

×Traditional data warehouse modeling without open table formats
×Real-time streaming processing without storage layer considerations
×Basic ETL pipeline design without lakehouse-specific optimizations
×Cloud storage optimization without table format considerations

Expects

Current data architecture details, workload patterns, engine ecosystem, and specific lakehouse requirements including performance, governance, and multi-engine compatibility needs.

Returns

Detailed lakehouse architecture blueprint with table format selection rationale, medallion layer design, schema evolution strategy, and implementation roadmap with specific configurations.

Evidence Policy

Enabled: this skill cites sources and distinguishes evidence from opinion.

data-lakehousedelta-lakeapache-icebergapache-hudimedallion-architecturetable-formattime-travelschema-evolutiondata-lakeparquetopen-table-format

Research Foundation: 8 sources (4 official docs, 2 academic, 2 industry frameworks)

This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.