DataAIHub
DataAIHubNews · Research · Tools · Learning
Back to AI Tools Directory

dbt

Freemium

Transform data in your warehouse using version-controlled SQL models.

Open SourceAPICloudSelf-hostedEnterpriseSQL SDKPython SDKJinja SDK

Tool Info

Categories
Data Engineering
Official Website
www.getdbt.com
Repository
dbt-labs/dbt-core
Official Docs

Overview

dbt is the standard transformation layer for modern ELT pipelines.

Analysts and engineers define models in SQL with tests, docs, and lineage.

Runs inside Snowflake, BigQuery, Redshift, Databricks, and other warehouses.

Pricing

Free tier available
Free (Core)Cloud (paid)Enterprise

Pros

  • Git-native SQL workflows
  • Built-in testing and docs
  • Huge community

Best For

Warehouse transformationsMetric definitionsData quality testing

When NOT to Use

  • Warehouse compute costs
  • Cloud features require subscription

Related Tools

Apache Spark
Unified analytics engine for large-scale data processing and ML workloads.
Apache Flink
Stream-first data processing engine for real-time analytics and event pipelines.
Apache Iceberg
Open table format for huge analytic datasets with ACID transactions on object storage.

Alternatives

Apache Spark
Unified analytics engine for large-scale data processing and ML workloads.

Often Compared With

Apache Spark
Unified analytics engine for large-scale data processing and ML workloads.

Compare With

Compare with Apache Spark

Tags

#data-engineering#elt#sql#transformation

Related Guides

Stay Updated

Get the latest AI news, tools, and engineering guides delivered to your inbox.

Subscribe to Newsletter