OBT Design Optimizer Overview Designs and optimizes One Big Table (OBT) patterns. This skill balances denormalization benefits with maintainability for analytical use cases. Capabilities - Column selection optimization - Denormalization strategy - Nested/repeated field design (BigQuery) - Clustering key selection - Partition strategy - Update frequency optimization - Query pattern analysis - Storage vs. performance tradeoffs Input Schema Output Schema Target Processes - OBT Creation - BI Dashboard Development - Query Optimization Usage Guidelines 1. Analyze source models and relationships 2.…