Doris setup
Overview of dbt-doris
- Maintained by: SelectDB
- Authors: long2ice,catpineapple
- GitHub repo: selectdb/dbt-selectdb
- PyPI package:
dbt-doris
- Slack channel: #db-doris
- Supported dbt Core version: v1.3.0 and newer
- dbt Cloud support: Not Supported
- Minimum data platform version:
Installing dbt-doris
pip is the easiest way to install the adapter:
pip install dbt-doris
Installing dbt-doris
will also install dbt-core
and any other dependencies.
Configuring dbt-doris
For Apache Doris / SelectDB-specifc configuration please refer to Apache Doris / SelectDB Configuration
For further info, refer to the GitHub repository: selectdb/dbt-selectdb
Connecting to Doris/SelectDB with dbt-doris
User / Password Authentication
Configure your dbt profile for using Doris:
Doris connection profile
profiles.yml
dbt-doris:
target: dev
outputs:
dev:
type: doris
host: 127.0.0.1
port: 9030
schema: database_name
username: username
password: password
Description of Profile Fields
Option | Description | Required? | Example |
---|---|---|---|
type | The specific adapter to use | Required | doris |
host | The hostname to connect to | Required | 127.0.0.1 |
port | The port to use | Required | 9030 |
schema | Specify the schema (database) to build models into, doris have not schema to make a collection of table or view' like PostgreSql | Required | dbt |
username | The username to use to connect to the doris | Required | root |
password | The password to use for authenticating to the doris | Required | password |
Database User Privileges
Your Doris/SelectDB database user would be able to have some abilities to read or write. You can find some help here with Doris privileges management.
Required Privilege |
---|
Select_priv |
Load_priv |
Alter_priv |
Create_priv |
Drop_priv |
0