skills.rest
PostHog
PostHogOFFICIAL
Explore all skills by this author →
Website𝕏@PostHogGitHub

tuning-incremental-sync-config

Modify data warehouse sync configurations for incremental fields, keys, frequency, and sync types.

58|5|Updated Jan 19, 2026
Search Tags:#incremental#data-warehouse#cdc#tune#sync-config#schema-drift
One-click install
npx skills add https://github.com/PostHog/skills --skill tuning-incremental-sync-config
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: tuning-incremental-sync-config
Source: https://github.com/PostHog/skills/tree/main/skills/omnibus/tuning-incremental-sync-config
Command: npx skills add https://github.com/PostHog/skills --skill tuning-incremental-sync-config

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Change the configuration of an existing data warehouse sync to switch sync_type, select a different incremental_field, update primary_key_columns, set cdc_table_mode, or adjust sync_frequency, all while preserving data integrity when possible.

Core Features & Use Cases

  • Update sync_type and incremental_field to adapt to new data patterns without re-creating schemas.
  • Adjust primary_key_columns or cdc_table_mode to align with downstream deduplication and CDC needs.
  • Change sync_frequency and related timing to optimize performance and reliability under drift or growth.

Quick Start

Switch to incremental sync using the new incremental_field and update the PKs, then trigger a reload to apply the new configuration.

Frequently Asked Questions about tuning-incremental-sync-config

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I change sync type from full refresh to incremental in a data warehouse?▼

To change sync type from full_refresh to incremental, you update the sync configuration to specify a new incremental_field. The Skill validates prerequisites and may trigger a resync to preserve data integrity when applying the new incremental sync settings.

When do I need to adjust incremental sync settings for schema drift?▼

You need to adjust incremental sync settings for schema drift when data patterns change and cause performance or accuracy issues. Tuning the incremental_field, primary_key_columns, or sync_frequency aligns the data warehouse sync with the new schema structure.

Can I update primary key columns and CDC table mode without recreating the schema?▼

Yes, you can update primary_key_columns and cdc_table_mode without re-creating schemas. This modifies the existing sync configuration directly to align with downstream deduplication and CDC needs while enforcing safety checks.

What happens to data integrity when switching sync types to CDC or webhook?▼

When switching sync types to cdc or webhook, data integrity is preserved when possible through enforced safety checks. The Skill provides guidance for resync operations if the configuration changes could invalidate existing data warehouse records.

What is the best way to optimize data warehouse sync frequency to handle data growth?▼

The best way to optimize sync frequency under data growth is adjusting the sync_frequency setting in the existing configuration. This tunes performance and reliability to address drift without recreating the schema or losing incremental sync state.

Related Skills

Explore More Data & Analytics Skills→
pradeepmoulipradeepmouli
2

speckit-workflows.baseline

Execute a script to generate baseline-spec.md and current-state.md from JSON output.

Community
Advanced
PostHogPostHog
58

diagnosing-failed-warehouse-syncs

Diagnose failing data warehouse syncs and map root causes to recovery actions.

Official
Advanced
marquesfelipmarquesfelip

replication-strategies

Design PostgreSQL and MySQL replication strategies with failover runbooks.

Community
Advanced
first-flukefirst-fluke
218

supabase-postgres-best-practices

Optimize PostgreSQL performance for Supabase applications across querying, indexing, schema design, and RLS.

Official
Advanced