Helpful Fivetran Tutorials
September 14, 2026 · SyncSpur Team
BigQuery accepts a Fivetran destination in five minutes and bills you for the defaults forever. A practical setup guide: least-privilege service accounts, dataset location, how the MERGE writes cost you, partitioning and clustering tables Fivetran owns, logical vs physical storage billing, and on-demand vs reservations.
Read moreSeptember 11, 2026 · SyncSpur Team
Your production Postgres has no public IP and security will not give it one. A practical guide to Fivetran's secure connectivity options - AWS PrivateLink, Azure Private Link, Google Private Service Connect, site-to-site VPN, reverse SSH and SSH tunnels - with the trade-offs, costs and a decision path that survives a security review.
Read moreSeptember 10, 2026 · SyncSpur Team
Fivetran schedules each connection independently, which breaks the moment your dbt run depends on three connectors finishing first. A practical tutorial on triggering and waiting on syncs from Airflow and Dagster: the REST API endpoints, deferrable sensors, signed sync_end webhooks, rate limits, and the one endpoint you must never automate.
Read moreSeptember 9, 2026 · SyncSpur Team
Your warehouse already knows which accounts are about to churn. Nobody in sales can see it. A hands-on tutorial on Census by Fivetran: modelling a syncable entity, choosing an identifier, configuring a first sync to Salesforce, handling API limits and failed records, and running the whole thing without overwriting data a rep typed by hand.
Read moreSeptember 9, 2026 · SyncSpur Team
Log-based change data capture for the databases that actually run the business. How Fivetran's HVR-based Oracle and SAP ERP connectors work, what redo log access and SAP cluster/pool tables demand of you, how to scope a first sync that does not blow up your MAR, and how to validate the result.
Read more