dbt

How it changes analytics work

dbt puts transformation logic in version-controlled SQL, then runs that logic inside your warehouse. Analysts can work with software-engineering habits: code review, reusable models, dependency management, automated checks, and deployment environments. It is strongest after data has already been loaded into platforms such as Snowflake, BigQuery, Redshift, or Databricks; it is not an ingestion tool or a database.

Choosing Core or Cloud

dbt Core is the free command-line project and remains practical for teams willing to own scheduling, hosting, and CI. dbt Cloud adds a browser IDE, managed jobs, credentials, governance controls, and vendor support. The free Cloud tier suits individual development; paid seats and enterprise features raise costs as a team grows.

• Core: Maximum control, more operational work.
• Cloud: Faster setup, centralized administration, recurring seat fees.