dbt is an open-source tool for transforming data inside a warehouse with version-controlled SQL models, tests and documentation. It covers the transform step of ELT.
Data modeling is designing how data is structured, named and related, so it can be stored efficiently and queried correctly. It applies to both application databases and analytics platforms.
A data warehouse is a central database built for analysis, holding cleaned, structured data from many systems. Analysts and BI tools query it for reports, dashboards and planning.
ETL (extract, transform, load) cleans and reshapes data before loading it into a target system. ELT (extract, load, transform) loads raw data first and does the transformation inside the target, usually a warehouse.
Reverse ETL is syncing modelled data from a warehouse back into operational tools such as CRMs, support desks and ad platforms. Teams can then act on it where they work.
A clear proven process, that delivers
You've seen our ideas - now go deeper.
Discover more insights, guides, and engineering practice.