Incremental model strategy selector

Skill a5c-ai/babysitter/library/specializations/data-engineering-analytics/skills/incremental-model-strategy-selector

Babysitter enforces obedience on agentic workforces and enables them to manage extremely complex tasks and workflows through deterministic, hallucination-free self-orchestration

Install

npx -y skills add a5c-ai/babysitter --skill incremental-model-strategy-selector

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

What its author says it does

Copied from the file, not written here

Selects and configures optimal incremental model strategies

SKILL.md

1.9 KB, as published. Nobody here has run it

Incremental Model Strategy Selector

Overview

Selects and configures optimal incremental model strategies. This skill optimizes data transformation efficiency through proper incremental processing patterns.

Capabilities

Incremental strategy selection (append, merge, delete+insert)
Partition pruning optimization
Unique key configuration
On_schema_change handling
Full refresh scheduling
Lookback window optimization
Late-arriving data handling

Input Schema

{
  "modelCharacteristics": {
    "sourceType": "string",
    "updatePattern": "append|update|delete",
    "volumeGB": "number",
    "updateFrequency": "string"
  },
  "platform": "snowflake|bigquery|redshift",
  "existingModel": "object"
}

Output Schema

{
  "strategy": "append|merge|delete+insert",
  "config": "object",
  "partitionStrategy": "object",
  "refreshSchedule": "object",
  "dbtConfig": "object"
}

Target Processes

Incremental Model Setup
dbt Model Development
Pipeline Migration

Usage Guidelines

Analyze source data update patterns
Measure data volume and update frequency
Select strategy based on characteristics
Configure appropriate lookback windows

Best Practices

Use append for insert-only sources
Use merge for sources with updates
Configure partition pruning for large tables
Schedule periodic full refreshes for data correction
Handle late-arriving data with appropriate lookback