dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

The Databricks Lakehouse provides one simple platform to unify all your data, analytics and AI workloads.

The dbt-databricks adapter contains all of the code enabling dbt to work with Databricks. This adapter is based off the amazing work done in dbt-spark. Some key features include:

• Easy setup. No need to install an ODBC driver as the adapter uses pure Python APIs.
• Open by default. For example, it uses the the open and performant Delta table format by default. This has many benefits, including letting you use MERGE as the the default incremental materialization strategy.
• Support for Unity Catalog. dbt-databricks>=1.1.1 supports the 3-level namespace of Unity Catalog (catalog / schema / relations) so you can organize and secure your data the way you like.
• Performance. The adapter generates SQL expressions that are automatically accelerated by the native, vectorized Photon execution engine.

If you are developing a dbt project on Databricks, we recommend using dbt-databricks for the reasons noted above.

dbt-spark is an actively developed adapter which works with Databricks as well as Apache Spark anywhere it is hosted e.g. on AWS EMR.

Install using pip:

pip install dbt-databricks

Upgrade to the latest version

pip install --upgrade dbt-databricks

your_profile_name:
  target: dev
  outputs:
    dev:
      type: databricks
      catalog: [optional catalog name, if you are using Unity Catalog, only available in dbt-databricks>=1.1.1]
      schema: [database/schema name]
      host: [your.databrickshost.com]
      http_path: [/sql/your/http/path]
      token: [dapiXXXXXXXXXXXXXXXXXXXXXXX]

These following quick starts will get you up and running with the dbt-databricks adapter:

• Developing your first dbt project
• Using dbt Cloud with Databricks (Azure | AWS)
• Running dbt production jobs on Databricks Workflows
• Using GitHub Actions for dbt CI/CD on Databricks

The dbt-databricks adapter has been tested:

• with Python 3.7 or above.
• against Databricks SQL and Databricks runtime releases 9.1 LTS and later.