Data Transformation Tools

dbt

dbt (data build tool) is an open-source command-line tool that enables data analysts and engineers to transform data in their warehouses by writing SQL queries. It provides a framework for building, testing, and documenting data transformation workflows, allowing users to version-control and modularize their SQL code. dbt handles tasks like dependency management, scheduling, and data quality testing, making it a key component in modern data stacks.

Also known as: data build tool, dbt-core, dbt Cloud, dbt Labs, DBT

🧊Why learn dbt?

Developers should learn dbt when working with data warehouses like Snowflake, BigQuery, or Redshift to streamline ETL/ELT processes and ensure reliable data transformations. It is particularly useful for creating maintainable and scalable data pipelines, enabling teams to collaborate on data models and implement best practices such as testing and documentation. Use cases include building analytics dashboards, data marts, and supporting business intelligence tools.

See how it ranks →

Compare dbt

dbt vs Airflow→dbt vs Databricks→dbt vs Fivetran→

Learning Resources

dbt Documentation

dbt Fundamentals Course

Getting Started with dbt - YouTube Tutorial

dbt: The Definitive Guide (Book)

Related Tools

Sql Data Warehousing Etl Data Modeling Snowflake

Alternatives to dbt

Airflow Databricks Fivetran

Other Data Transformation Tools

.env is a file format and tool used to store environment variables, which are key-value pairs that configure application settings like API keys, database URLs, and other sensitive or environment-specific data. It allows developers to separate configuration from code, making applications more secure and portable across different environments (e.g., development, testing, production). Tools like dotenv in Node.js or python-dotenv in Python parse .env files to load these variables into the application's environment at runtime.

.htaccess (Hypertext Access) is a configuration file used on Apache web servers to control directory-level settings, such as URL redirection, access control, and performance optimizations. It allows developers to override global server configurations for specific directories without modifying the main server configuration files. This file is commonly used for tasks like enabling HTTPS, blocking IP addresses, or setting custom error pages.

2D Drafting is the process of creating technical drawings and schematics in two dimensions using specialized software, primarily for engineering, architecture, and manufacturing design. It involves producing precise, scaled representations of objects, components, or structures with detailed annotations, dimensions, and symbols to communicate design intent and specifications. This skill is foundational for translating conceptual ideas into actionable plans for construction, fabrication, or analysis.

2D Drafting Tools

2D drafting tools are software applications used to create precise technical drawings, schematics, and blueprints in two dimensions. They enable engineers, architects, and designers to produce detailed plans with accurate measurements, annotations, and geometric shapes. These tools are essential for documenting designs before moving to 3D modeling or physical construction.

2D Drawing Review

2D Drawing Review refers to the process and software tools used to examine, annotate, and collaborate on two-dimensional technical drawings, such as blueprints, schematics, or CAD designs. It involves checking for accuracy, compliance with standards, and identifying errors or improvements in engineering, architecture, or manufacturing contexts. Tools for this purpose often include features like markup, version control, and real-time collaboration to streamline review cycles.

2D Graphics Software

2D graphics software refers to computer programs used to create, edit, and manipulate two-dimensional digital images, illustrations, and designs. These tools provide features like drawing, painting, vector graphics, image editing, and layout design for applications such as digital art, UI/UX design, game sprites, and print media. They range from professional suites like Adobe Photoshop to free alternatives like GIMP and Inkscape.