Declarative Data Source Connector With Schema Inference

via “declarative schema inference from nested json and structured data”

Python data load tool with automatic schema inference.

Unique: Uses a recursive type inference engine with schema versioning (dlt/common/schema/typing.py) that tracks schema changes across pipeline runs, enabling automatic detection of new columns and type migrations without manual intervention. Supports destination-specific type mapping (e.g., DECIMAL vs NUMERIC in different SQL dialects) through pluggable type converters.

vs others: Faster schema adaptation than Fivetran or Stitch because schema changes are detected locally before load, avoiding failed loads and manual remediation; more flexible than dbt because it handles schema inference without requiring pre-written YAML models.