Skip to main content

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

target: dev
type: doris
port: 9030
schema: database_name
username: username
password: password

Description of Profile Fields

typeThe specific adapter to useRequireddoris
hostThe hostname to connect toRequired127.0.0.1
portThe port to useRequired9030
schemaSpecify the schema (database) to build models into, doris have not schema to make a collection of table or view' like PostgreSqlRequireddbt
usernameThe username to use to connect to the dorisRequiredroot
passwordThe password to use for authenticating to the dorisRequiredpassword

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