data build tool (dbt)#
dbt is an open source, command-line tool managed by dbtlabs for generating and maintaining data transformations.
dbt allows engineers to transform data by writing SELECT
statements that reflect business logic which dbt
materializes into tables and views that can be queried efficiently.
dbt also allows engineers to modularize and re-use their transformation code using “packages” that can be shared across projects or organizations.
dbt in Aspects#
Aspects uses the aspects-dbt package to define the transforms used by the Aspects project. This package creates and manages macros and materialized views for data tables stored in Clickhouse, and provides some tests.
Operators may create and install their own dbt packages; see Extending dbt for details.
tutor-contrib-aspects also provides a “do” command to proxy running dbt commands against your deployment; run
tutor [dev|local] do dbt --help
for details.
References#
dbtlabs: dbt documentation
dbt-core: core dbt package
aspects-dbt: Aspects dbt transforms
tutor-contrib-aspects: Aspects Tutor plugin