Skip to main content

Databend Cloud setup

Vendor-supported plugin

Some core functionality may be limited. If you're interested in contributing, check out the source code repository listed below.

Overview of dbt-databend-cloud

  • Maintained by: Databend Cloud
  • Authors: Shanjie Han
  • GitHub repo: databendcloud/dbt-databend
  • PyPI package: dbt-databend-cloud
  • Slack channel: #db-databend-cloud
  • Supported dbt Core version: v1.0.0 and newer
  • dbt Cloud support: Not Supported
  • Minimum data platform version: n/a

Installing dbt-databend-cloud

pip is the easiest way to install the adapter:

pip install dbt-databend-cloud

Installing dbt-databend-cloud will also install dbt-core and any other dependencies.

Configuring dbt-databend-cloud

For Databend Cloud-specifc configuration please refer to Databend Cloud Configuration

For further info, refer to the GitHub repository: databendcloud/dbt-databend

Connecting to Databend Cloud with dbt-databend-cloud

User / Password Authentication

Configure your dbt profile for using Databend Cloud:

Databend Cloud connection profile

profiles.yml
dbt-databend-cloud:
target: dev
outputs:
dev:
type: databend
host: databend-cloud-host
port: 443
schema: database_name
user: username
pass: password

Description of Profile Fields

OptionDescriptionRequired?Example
typeThe specific adapter to useRequireddatabend
hostThe host (hostname) to connect toRequiredyourorg.datafusecloud.com
portThe port to useRequired443
schemaSpecify the schema (database) to build models intoRequireddefault
userThe username to use to connect to the hostRequireddbt_admin
passThe password to use for authenticating to the hostRequiredawesome_password

Database User Privileges

Your database user would be able to have some abilities to read or write, such as SELECT, CREATE, and so on. You can find some help here with Databend Cloud privileges management.

Required Privilege
SELECT
CREATE
CREATE TEMPORARY TABLE
CREATE VIEW
INSERT
DROP
SHOW DATABASE
SHOW VIEW
SUPER

Supported features

okFeature
Table materialization
View materialization
Incremental materialization
Ephemeral materialization
Seeds
Sources
Custom data tests
Docs generate
Snapshots
Connection retry

Note:

  • Databend does not support Ephemeral and SnapShot. You can find more detail here
0