ELT: A modern paradigm for modern architectures
Cloud data platforms—and the separation of storage and compute—have ushered in a new paradigm for data transformation.
Data teams around the world love dbt
Accelerate your data pipelines with ELT
Get more mileage out of your data
Traditional ETL locks you in to defining how you want to use your raw data before you even collect it. ELT gives you the flexibility to model your data on-the-fly with the freedom to iterate for current and future use cases. Explore and re-use existing data assets to save time, resources, and deliver insights faster. And since transformations happen directly in your data platform, you can maintain control of the entire process without other tooling.
Empower more users to build and deploy analytics code
Relieve the lift on data engineers and empower anyone who knows SQL to build and deploy transformation logic. That means data analysts can shape and ship analytics code and more people can self-serve data insights. Data consumers of all stripes can query data from their analytics tool and get consistent metrics—every time—with definitions defined centrally in the dbt Semantic Layer.
Black box, begone
Debugging a pipeline or transformation issue with traditional ETL solutions can be opaque and frustratingly time-consuming. Ship trusted analytics code faster by incorporating software development best practices into every transformation run. With built-in testing, version control, CI/CD, automated documentation, and lineage across staged environments, data teams will spend less time putting out fires and more time shipping quality code.
Reduce complexity without sacrificing governance
dbt supports a mesh paradigm so users can divvy-up large projects into manageable data domains. Central data teams have the control to define guardrails, set standards, and build contracts. Domain teams move faster with a more focused purview into the data lineage that is relevant to their work.
Integrate across the modern data stack
We support dozens of integrations across the modern data stack so you can transform your data wherever it lives, and send it wherever it needs to go. We’re honored to have been named “Partner of the Year” by both Snowflake and Databricks in addition to Databricks’ fastest-growing data and AI product of the year.
See dbt in action
Explore how dbt Labs has helped to achieve better clients outcomes, increase efficiency, and grow their business with customer case studies.
Sunrun enables last mile modeling with dbt Cloud
With data teams spanning several business functions, we didn't just need a way to standardize development. We needed a way for those processes to be easily understood by everyone—seasoned engineers, new analysts, the CFO... everyone.
Jared Stout, Head of Data Management
Start building with dbt
Streamline your data transformation process, reduce manual errors, and increase productivity with dbt. Sign up today and take your data transformation workflow to the next level.