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-cloudSupported 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
EphemeralandSnapShot. 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]
| 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 |
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.
