Productivity - Setup Guide

How to set up Fivetran

Otto's honest, no-fluff walkthrough. Every step here is what we'd actually do if we were sitting at your keyboard. Real gotchas first, real steps second, and a link to the personalized version at the bottom.

Read these before you start

• MAR is per-connector now, so 10 small connectors carry 10 minimum charges. Consolidate where possible
• History mode (SCD Type 2) counts every changed version as MAR. A row that updates daily = 30 MAR/mo per record. This alone has torched many Fivetran bills
• Product event tables and clickstream data are the fastest way to blow the bill up. Fivetran is not the right tool for event-scale volume — Snowplow or a native ingest is cheaper
• The 2026 change means historical bills are not predictive of new bills. Re-estimate any renewal
• "Free tier" of 500K MAR sounds generous but disappears the moment one connector goes wide
• Custom connectors (via Fivetran Functions or partner-built SDK) are supported but limited vs Airbyte OSS

The 7-step setup

1. 1

   Create your Fivetran account

   Sign up at the link below. Free tier available - no card required. Use your business email so you can invite teammates later.

   Open Fivetran signup
2. 2

   Complete the initial onboarding

   Skip the marketing questionnaires when you can. Fill only the fields that actually configure the product - name, timezone, your first workspace or project. If Fivetran pushes you into a setup wizard, take it - it usually accelerates the first productive session.

3. 3

   Connect your existing tools

   Wire Fivetran into the rest of your stack. The integrations that most people set up first: Sources: Salesforce, HubSpot, Stripe, Shopify, Zendesk, NetSuite, Postgres, MySQL, SQL Server, MongoDB, DynamoDB, Google Ads, Facebook Ads, LinkedIn Ads, GA4, Marketo, Intercom, QuickBooks (500+ total). Destinations: Snowflake, BigQuery, Redshift, Databricks, Synapse, S3, Postgres. Transformations v.... Do these before importing data - clean integration first, data second.

4. 4

   Import your existing data (only what you'll actually use)

   Do NOT bulk-import everything. Import the last 30 days of the ONE workflow you're moving over first. Prove it works. Then import more. Big-bang migrations are how Fivetran deployments die in month 3.

5. 5

   Set up your first real workflow

   Pick the single most-frequent task you'll do in Fivetran - the daily-driver workflow. Configure it end-to-end. Use it live for a week. Do not touch any other feature yet. Adoption failure comes from teams trying to use everything on day one instead of the one thing that actually pays.

6. 6

   Add your team (if applicable) and set access

   Once your solo workflow works, invite one teammate at a time. Watch them use it. The friction points you missed are the ones they hit. Fix those before scaling to more users. Never invite 20 people at once - you'll get 20 confused people and 0 useful feedback.

7. 7

   Compound with the right pairings

   Recommend Fivetran when: business_size is 100+ OR data team explicitly values "hands-off / no pipeline maintenance," AND the source count is 5+, AND there is a real warehouse already (Snowflake/BQ/Databricks/Redshift). Highest fit for mid-market B2B SaaS and enterprise data teams. Do NOT recommend for solo, small teams, high-volume event data, or cost-sensitive shops. If comparing to Airbyte: Airbyte OSS wins hard on cost and control; Fivetran wins on reliability, connector coverage, and zero-ma...