Incremental Model Strategy Selector

SkillAI & models

Selects and configures optimal incremental model strategies

Instructions available. Your AI can read the instructions. Execution depends on the setup they require.

Account requirements not reviewed. Check the skill instructions before use; ahel provides instructions and does not run this skill.

Add ahel to your AI once: Claude, ChatGPT, Cursor, Claude Code or Codex. Then ask it to use this.

Then ask your AI: use the Incremental Model Strategy Selector skill

What this skill tells your AI

The instructions your AI receives, as published by a5c-ai/babysitter in library/specializations/data-engineering-analytics/skills/incremental-model-strategy-selector/SKILL.md and read by ahel’s review.

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

Signals

GitHub stars: 2k
Forks: 112
Last commit: Sep 2026

Advanced

Item type: skill
Key: incremental-model-strategy-selector
Source: github.com/a5c-ai/babysitter

github.com/a5c-ai/babysitter