Designs and optimizes One Big Table (OBT) patterns
Designs and optimizes One Big Table (OBT) patterns. This skill balances denormalization benefits with maintainability for analytical use cases.
{
"sourceModels": ["object"],
"queryPatterns": ["object"],
"platform": "snowflake|bigquery|redshift",
"constraints": {
"maxColumns": "number",
"refreshFrequency": "string"
}
}
{
"obtDesign": {
"columns": ["object"],
"clustering": ["string"],
"partitioning": "object"
},
"buildStrategy": "object",
"refreshConfig": "object",
"estimatedQueryImprovement": "percentage"
}