Connect Doris to dbt Core

• 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 support: Not Supported
• Minimum data platform version:

Installing dbt-doris

Use pip to install the adapter. Use the following command for installation:

python -m pip install dbt-doris

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

Loading table...

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

Loading table...

Was this page helpful?

Privacy policyCreate a GitHub issue

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.