Company
Date Published
Author
Elan Adler, Alex Hauer
Word count
1073
Language
English
Hacker News points
None

Summary

Fivetran's analytics engineering team has developed a robust library of open-source dbt data models that help customers turn raw connector data into analytics-ready tables. These data models are used by over 1,000 new projects each month and can be accessed by anyone. The data models extend the connector entity relationship diagrams (ERDs) to create these analytics-ready tables, which perform foundational work that occupies an analyst's time. They identify relevant entities in the ERD and perform transformations, ultimately producing output tables needed for analytical workflows. Fivetran's data models facilitate the process of generating a general ledger from QuickBooks schema by identifying necessary tables, creating intermediate models, and consolidating data to provide a comprehensive understanding of transactions. The team maintains and updates these data models based on customer feedback, ensuring they include all transaction types and rework is not needed. With Fivetran's data models, customers can accelerate their time to insight and spend less time building and maintaining ELT pipelines.