Skip to main content

The Databend plugin for dbt (data build tool)

Project description

dbt logo



The dbt-databend package contains all of the code enabling dbt to work with Databend.

Getting started


Use your favorite Python package manager to install the app from PyPI, e.g.

python -m pip install dbt-databend

Supported features

Databend does not support a ALTER query for change a tables schema. So some features are not available.

  • Table materialization
  • View materialization
  • Incremental materialization
  • Seeds
  • Sources
  • Docs generate
  • Tests
  • Snapshots
  • Ephemeral materialization

Database & schema

The dbt model database.schema.table is not compatible with Databend because Databend does not support a schema. So we use a simple model schema.table, where schema is the Databend's database.


Option Description Required?
cluster_by For detailed information about the CLUSTER BY clause, see SET CLUSTER KEY. Optional (default: empty)

Profile Configuration

Databend targets should be set up using the following configuration in your profiles.yml file. The dbt-databend package usage mysql-procotol for connect to database.

  target: dev
      type: databend
      host: [hostname]
      port: [port]  # default 3307
      user: [username]
      password: [password]
      schema: [database name]

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbt-databend-1.1.0.tar.gz (11.5 kB view hashes)

Uploaded source

Built Distribution

dbt_databend-1.1.0-py2.py3-none-any.whl (11.5 kB view hashes)

Uploaded py2 py3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page