Home / Companies / Fivetran / Blog / Post Details
Content Deep Dive

How to (Re)Use dbt: Guiding Rapid MDS Deployments

Blog post from Fivetran

Post Details
Company
Date Published
Author
Josh Hall
Word Count
1,271
Company Posts That Month
28
Language
English
Hacker News Points
-
Post removed?
No
Summary

The open-source tool dbt has revolutionized data modeling by enabling software engineering principles for data analysts, analytics engineers, and data engineers. Its reusability of code allows the creation of "best-practice transforms" for widely adopted data sources, leading to a library of standardized schemas and reusable code for all data teams. The three major dbt components that facilitate this reusability are packages, macros, and dependencies. Packages enable rapid extensibility by containing macros and models, allowing users to leverage work done by other data professionals within their projects. Macros leverage Jinja to create templates, enabling loops, modularization, and repetition of business logic. Dependencies are created through the ref function, which allows one model to depend on another being referenced, creating a dependent acyclic graph (DAG) of the entire data model. By leveraging these components, dbt can rapidly deploy modern data stacks for clients in days instead of months, ensuring that every company obtains the necessary data modeling to empower decision-making.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.