Data build tool
≈ 1 min read
Names in other languages
No names in other languages are held for this entry yet.
Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.
Data build tool (dbt) is an open-source command line tool that helps analysts and engineers transform data in their warehouse more effectively.
Data build tool (dbt) is an open-source command line tool that helps analysts and engineers transform data in their warehouse more effectively.
Overview
Dbt enables analytics engineers to transform data in their warehouses by writing select statements, and turns these select statements into tables and views. Dbt does the transformation (T) in extract, load, transform (ELT) processes – it does not extract or load data, but is designed to be performant at transforming data already inside of a warehouse. Dbt has the goal of allowing analysts to work more like software engineers, in line with the dbt viewpoint. Dbt uses YAML files to declare properties. seed is a type of reference table used in dbt for static or infrequently changed data, like for example country codes or lookup tables), which are CSV based and typically stored in a seeds folder.
References
Text derived from https://en.wikipedia.org/w/index.php?oldid=1374717550 under CC BY-SA 4.0; modifications have been made.