data academy
Demystifying the transactional database
Transactional databases are essential to many apps and software. Learn more about them and their benefits with Fivetran.
Build vs. buy data pipelines: Costs to consider
A few simple calculations illustrate why it's ill-advised to build your own data pipeline.
The modern data science stack
Automated data integration can help you jump-start your machine learning efforts.
What is the architecture of automated data integration?
Automated data integration depends on several key concepts.
Announcing the Modern Data Stack Boot Camp
Learn how to set up a modern data stack and transform your analytics in three steps.
Databases Demystified Chapter 10 – Query Planning and Optimization
Take a look under the hood to learn how you can help databases execute queries more efficiently.
Databases Demystified Chapter 9 – Indexes
Indexes aren’t just for catalogs or textbooks. Learn how indexes make queries faster.
Databases Demystified Chapter 8 – Distributed Databases Part 3
What is “consensus,” and what does it have to do with distributed databases?
Databases Demystified Chapter 7 – Distributed Databases Part 2
Distributed databases are powerful, but they come with lots of complications.
Databases Demystified Chapter 5 – Transactions Part 2
Learn about the relationship between isolation and concurrency.
Databases Demystified Chapter 4 – Transactions Part 1
Take a deep dive into transactional databases.
Databases Demystified Chapter 3 – Row Store vs. Column Store
Take a closer look at the differences in architecture between row- and column-based databases
Databases Demystified Chapter 1 – Databases and SQL
Learn about the history of databases, important terminology, and different types of databases you might encounter.
What is idempotence?
Idempotence is an important characteristic of many systems, including Fivetran. Here's what it means.
Three kinds of metrics GitHub data can answer
Data from GitHub can help your engineers quantify how they are doing.
Five dashboards to jump-start your analytics
Consider building these dashboards that help answer essential business questions.
How no-code empowers non-engineers without sacrificing data and analytics
You don’t have to build all of the systems that support your business functions.
Use Fivetran to sync any unsupported source
Learn how Fivetran cloud function connectors can pull data when there is no prebuilt connector.
Why you need automated schema migration
Schema changes can completely disrupt a data pipeline. Automated data integration offers a solution.
How to organize your analytics team
People and processes matter as much as your technology stack.
How to migrate your enterprise data warehouse to a cloud data warehouse
The modern data stack lives in the cloud. Here are the steps you'll need to take to migrate your on-prem system.
The definitive glossary of data integration terms
New to analytics? Don’t know what an ERD is? Read this comprehensive list of important data integration terms.
How Fivetran built its Klaviyo connector
The process of building a connector is inextricably linked with schema design.
Start for free
Join the thousands of companies using Fivetran to centralize and transform their data.