Database Schema Design Guide

Fivetran builds data connectors by designing normalized schemas to structure data from SaaS applications. The process involves understanding the application's purpose and major workflows, drafting an ERD (entity-relationship diagram) based on the underlying data model, studying the API, creating draft tables using the API response, applying Fivetran naming conventions, linking and normalizing tables, reviewing isolated tables, publishing the ERD, and developing the connector. The ERD is crucial as it visually represents interrelations between tables and dictates the behavior of the connector.