Doris setup

• Maintained by: SelectDB
• Authors: catpineapple,JNSimba
• GitHub repo: selectdb/dbt-doris
• 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

Use pip to install the adapter. Before 1.8, installing the adapter would automatically install dbt-core and any additional dependencies. Beginning in 1.8, installing an adapter does not automatically install dbt-core. This is because adapters and dbt Core versions have been decoupled from each other so we no longer want to overwrite existing dbt-core installations. Use the following command for installation:

Configuring dbt-doris

For Apache Doris / SelectDB-specific configuration, please refer to Apache Doris / SelectDB configs.

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