dbt logo

dbt

A command line tool that enables data analysts and engineers to transform data in their warehouse more effectively.
57
58
+ 1
0

What is dbt?

dbt - Documentation
dbt is a tool in the Database Tools category of a tech stack.

Who uses dbt?

Companies
15 companies reportedly use dbt in their tech stacks, including Data, Mathspace, and Affirm.

Developers
40 developers on StackShare have stated that they use dbt.
Pros of dbt
Be the first to leave a pro
Private Decisions at about dbt

Here are some stack decisions, common use cases and reviews by members of with dbt in their tech stack.

Shared insights
on
dbtdbtGoogle BigQueryGoogle BigQuery

I used dbt over manually setting up python wrappers around SQL scripts because it makes managing transformations within Google BigQuery much easier. This saves future Sung dozens of hours maintaining plumbing code to run a couple SQL queries. Check out my tutorial in the link!

I haven't seen any other tool make it as easy to run dependent SQL DAGs directly in a data warehouse.

See more
Public Decisions about dbt

Here are some stack decisions, common use cases and reviews by companies and developers who chose dbt in their tech stack.

Ankit Sobti
Ankit Sobti
CTO at Postman Inc | 12 upvotes 192.5K views

Looker , Stitch , Amazon Redshift , dbt

We recently moved our Data Analytics and Business Intelligence tooling to Looker . It's already helping us create a solid process for reusable SQL-based data modeling, with consistent definitions across the entire organizations. Looker allows us to collaboratively build these version-controlled models and push the limits of what we've traditionally been able to accomplish with analytics with a lean team.

For Data Engineering, we're in the process of moving from maintaining our own ETL pipelines on AWS to a managed ELT system on Stitch. We're also evaluating the command line tool, dbt to manage data transformations. Our hope is that Stitch + dbt will streamline the ELT bit, allowing us to focus our energies on analyzing data, rather than managing it.

See more
Shared insights
on
dbtdbtGoogle BigQueryGoogle BigQuery

I used dbt over manually setting up python wrappers around SQL scripts because it makes managing transformations within Google BigQuery much easier. This saves future Sung dozens of hours maintaining plumbing code to run a couple SQL queries. Check out my tutorial in the link!

I haven't seen any other tool make it as easy to run dependent SQL DAGs directly in a data warehouse.

See more
Wei Wei
Wei Wei
Shared insights
on
dbtdbt
at

Neat data transformation tool and only focusing on data transformation. Fitting the popular ELT paradigm. Small but active community. Easy to get help on their Slack from maintainers. dbt

See more

dbt Alternatives & Comparisons

What are some alternatives to dbt?
act
Rather than having to commit/push every time you want test out the changes you are making to your .github/workflows/ files (or for any changes to embedded GitHub actions), you can use this tool to run the actions locally. The environment variables and filesystem are all configured to match what GitHub provides.
Airflow
Use Airflow to author workflows as directed acyclic graphs (DAGs) of tasks. The Airflow scheduler executes your tasks on an array of workers while following the specified dependencies. Rich command lines utilities makes performing complex surgeries on DAGs a snap. The rich user interface makes it easy to visualize pipelines running in production, monitor progress and troubleshoot issues when needed.
Looker
We've built a unique data modeling language, connections to today's fastest analytical databases, and a service that you can deploy on any infrastructure, and explore on any device. Plus, we'll help you every step of the way.
Apache Spark
Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
See all alternatives

dbt's Followers
58 developers follow dbt to keep up with related blogs and decisions.
Rahul Mathur
eric m茅ni猫re
Srikanth Marella
amit sinha
Carlos Andr茅s Gonz谩lez
Pablo Mora
Patrick Park
taylor brandt
MrBamshy .
Akioma9