dbt

dbt has become the industry standard for SQL-based data transformation, enabling teams to apply software engineering practices to analytics. It focuses narrowly on the transformation layer rather than end-to-end data movement. The tool integrates with major cloud warehouses and has a thriving ecosystem.

Users appreciate the predictable pricing model and excellent documentation, as well as the ability to version control data transformations. The dbt Cloud offering provides scheduling and CI/CD capabilities. The main limitation is that dbt only handles the T in ELT—you still need separate tools for extraction and loading.

Performance is generally solid, though complex transformations can struggle at massive scale without optimization.