Skip to main content

Connect Doris to dbt v1

  • Maintained by: SelectDB
  • Authors: catpineapple,JNSimba
  • GitHub repo: selectdb/dbt-doris
  • PyPI package: dbt-doris
  • Slack channel: #db-doris
  • Supported dbt 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

Report incorrect code

Description of Profile Fields​

OptionDescriptionRequired?Example
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
Select_priv
Load_priv
Alter_priv
Create_priv
Drop_priv

Was this page helpful?

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

0
Loading