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:

python -m 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