Overview of dbt adapters

This topic describes how dbt enables data analysts and engineers to transform data in their warehouse, and how Cloudera provides adapters for seamless integration.

dbt (data build tool) is an open-source command-line tool that enables data analysts and engineers to transform data in their warehouse by writing SQL SELECT statements. dbt applies best practices, such as version control, testing, and documentation to the data transformation workflow. Cloudera provides specialized adapters, the dbt-hive and dbt-impala, to integrate dbt seamlessly with its data platforms.

dbt core functionality allows users to build and manage data transformation pipelines directly on their data warehouses. This includes creating tables, views, and incremental models, as well as performing data testing and documentation. For more information, see Understanding dbt.

Adapter overview

The dbt-hive and dbt-impala adapters are developed to provide native connectivity and optimized performance when transforming data within Hive and Impala warehouses on Cloudera.

Support and maintenance

Cloudera maintains and supports both the dbt-hive and dbt-impala adapters. This ensures their functionality and compatibility with Cloudera environments, providing ongoing support for users.

Supported versions

Cloudera supports dbt version 1.8.0 or higher for the dbt-core, dbt-hive, and dbt-impala adapters. For the latest information about dbt versions, refer to dbt versions.