dbt

dbt is a development environment that speaks the preferred language of data analysts everywhere—SQL. With dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation.With dbt, you write data transformation code following one of the oldest software engineering best practices: modularity. Writing modular SQL means your queries are easier to update and troubleshoot and will execute dramatically faster.It enables the automation of data quality testing. With critical decisions based on data, you need your entire organisation to trust that data. dbt includes a robust testing framework so you can define and test assumptions about your data sources and the results of your data transformations. This helps you to create transparency throughout your analytics engineering workflow, giving analysts and business stakeholders visibility into what the data is describing, how it was produced, and how it maps to business logic.