dbt Core

Open-source data transformation tool for SQL data modelling, data warehouses and reproducible data pipelines.

Details

dbt Core is an open-source data transformation tool that manages data models, dependencies, tests and documentation with SQL and configuration files. It suits data warehouses, database analytics, reproducible data processing and team data engineering workflows.

Use cases: SQL data modelling, data warehouses, data transformation, data testing, data engineering

Note: dbt Core suits database/data warehouse scenarios; for ordinary CSV analysis use Python, R or DuckDB.