dbt

The product is a data transformation platform that lets teams build, test, document and version-control SQL-based data models and pipelines for analytics and AI. It solves problems of data quality, governance, lineage visibility and inefficient warehouse compute when preparing trusted datasets. It is for data practitioners, analytics engineers and developers in business data teams. It is delivered as a cloud SaaS platform and open-source framework that does not store customer data and integrates with existing warehouses and tools via open standards.

Key features

• Transform data with SQL
• Modular tested version-controlled pipelines
• Native SQL comprehension and local validation
• Multi-dialect compilation for portability
• Interactive lineage across projects and columns
• Column-level lineage tracing
• Automatically refactor models and columns
• Preview proposed changes before commit
• Stateful orchestration building only changed models
• IDE extensions for VS Code and others
• Deep ecosystem integrations
• Automated testing and documentation