dbt-databend-cloud

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

Table of Contents

• Installation
• Supported features
• Profile Configuration
• Database User Privileges
• Running Tests
• Example
• Contributing

Installation

Compile by source code.

$ git clone https://github.com/databendcloud/dbt-databend.git
$ cd dbt-databend
$ pip install .

Also, you can get it from pypi.

$ pip install dbt-databend-cloud

Supported features

ok	Feature
✅	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

Profile Configuration

Databend Cloud targets should be set up using the following configuration in your profiles.yml file.

Example entry for profiles.yml:

Your_Profile_Name:
  target: dev
  outputs:
    dev:
      type: databend
      host: [host]
      port: [port]
      schema: [schema(Your database)]
      user: [username]
      pass: [password]
      secure: [SSL]

Option	Description	Required?	Example
type	The specific adapter to use	Required	databend
host	The server (hostname) to connect to	Required	yourorg.databend.com
port	The port to use	Required	443
schema	Specify the schema (database) to build models into	Required	analytics
user	The username to use to connect to the server	Required	dbt_admin
pass	The password to use for authenticating to the server	Required	correct-horse-battery-staple
secure	The SSL of host (default as True)	Optional	True

Note:

• You can find your host, user, pass information in this docs

Running Tests

See tests/README.md for details on running the integration tests.

Example

Click here to see a simple example about using dbt with dbt-databend-cloud.

Contributing

Welcome to contribute for dbt-databend-cloud. See Contributing Guide for more information.