Fivetran

Fivetran is a commercial cloud-based data integration platform that automates the extraction and loading of data from various sources (SaaS applications, databases, file stores) into destinations such as a Data Warehouse or Data Lakehouse.

Key Characteristics

Fivetran follows an ELT (Extract, Transform, Load) methodology rather than traditional ETL, loading raw source data directly into the target platform and leaving transformations to downstream tools like DBT (Data Build Tool).

  • Fully Managed Connectors: Offers zero-configuration pipelines that automatically adapt to schema changes (schema drift) in source APIs or databases.
  • Incremental Loading: Uses log-based CDC (Change Data Capture) to capture and replicate only updated or new records, reducing source system overhead and network transfer times.
  • Idempotency & Re-sync: Ensures that data delivery is resilient to failures by maintaining sync state, allowing pipelines to resume seamlessly without duplicating or corrupting destination tables.

By abstracting API maintenance, schema mapping, and pipeline scaling, Fivetran acts as a key ingestion engine in modern data stack configurations.

Part of the Data & AI Terms glossary.

This page is mirrored from the GitHub Wiki. View original on GitHub