How to Set Up Your First Fivetran Data Pipeline in 2026
Fivetran is a managed ELT service that copies data from sources like Postgres, Salesforce, and Shopify into a warehouse such as BigQuery or Snowflake. You configure a connector in the UI; Fivetran handles extraction, schema drift, and incremental syncs.
What Does Fivetran Actually Do?
It replaces hand-written sync scripts. Instead of scheduling cron jobs and debugging broken API calls, you authorize a source and Fivetran runs the pipeline, retries failures, and keeps the destination schema in sync. The tradeoff is cost: Fivetran bills by monthly active rows (MAR), which surprises teams that sync high-volume tables without filtering.
How to Connect Your First Source
- Log in and click Add Connector, then pick your source type.
- Enter credentials or connect via OAuth. For a database, use a read-only user.
- Choose the destination warehouse and schema name.
- Select which tables to sync — start with 3-5, not all 200.
- Set the sync frequency: 15 minutes to 24 hours.
- Click Save & Start. The first sync backfills history, which can take hours on large tables.
How Does Fivetran Pricing Work?
Pricing is usage-based on monthly active rows. The Free plan covers 500,000 MAR per month, which is enough for a small internal analytics project. Paid plans start around $500/month for the Standard tier with more MAR, higher sync frequency, and priority support.
| Plan | Monthly active rows | Typical use |
|---|---|---|
| Free | 500K MAR | Evaluation, small projects |
| Standard | Usage-based (~$500/mo min) | Growing teams |
| Enterprise | Custom | Governance and SSO needs |
How Do You Keep Costs From Spiraling?
Exclude noisy columns and tables you never query. A single high-churn table can dominate your MAR. Use column selection in the connector settings and pause connectors you don’t need during development. Review the Usage dashboard weekly for the first month.
Is Fivetran Worth It vs. DIY Scripts?
If you sync more than two or three sources, yes. Maintaining custom connectors costs engineer time that dwarfs the subscription for most teams. If you have one small Postgres table moving once a day, a scheduled dbt or Airbyte job on your own infra is cheaper.
Common Setup Mistakes
- Using an admin DB user instead of a read-only one.
- Syncing every table on day one and blowing the free tier.
- Ignoring schema changes — Fivetran adapts, but downstream dbt models may break.
Quick Summary
- Fivetran is managed ELT: authorize a source, pick a warehouse, sync.
- Free tier covers 500,000 monthly active rows.
- Paid plans start around $500/month, billed on MAR.
- Exclude unused tables/columns to control cost.
- Worth it for 3+ sources; overkill for a single small table.
