Skip to main content

YDB setup

Overview of dbt-ydb

  • Maintained by: YDB Team
  • Authors: YDB Team
  • GitHub repo: ydb-platform/dbt-ydb
  • PyPI package: dbt-ydb
  • Slack channel: n/a
  • Supported dbt Core version: v1.8.0 and newer
  • dbt support: Not Supported
  • Minimum data platform version: n/a

Installing dbt-ydb

pip is the easiest way to install the adapter:

python -m pip install dbt-ydb

Installing dbt-ydb will also install dbt-core and any other dependencies.

Configuring dbt-ydb

For YDB-specifc configuration please refer to YDB Configuration

For further info, refer to the GitHub repository: ydb-platform/dbt-ydb

Connecting to YDB​

To connect to YDB from dbt, you'll need to add a profile to your profiles.yml file. A YDB profile conforms to the following syntax:

profiles.yml
profile-name:
  target: dev
  outputs:
    dev:
      type: ydb
      host: localhost
      port: 2136
      database: /local
      schema: empty_string
      secure: False
      root_certificates_path: empty_string

      # Static credentials
      username: empty_string
      password: empty_string

      # Access token credentials
      token: empty_string

      # Service account credentials
      service_account_credentials_file: empty_string

All configurations​

ConfigRequired?DefaultDescription
hostYesYDB host
portYesYDB port
databaseYesYDB database
schemaNoempty_stringOptional subfolder for dbt models. Use empty string or / to use root folder
secureNoFalseIf enabled, grpcs protocol will be used
root_certificates_pathNoempty_stringOptional path to root certificates file
usernameNoempty_stringYDB username to use static Ccredentials
passwordNoempty_stringYDB password to use static credentials
tokenNoempty_stringYDB token to use Access Token credentials
service_account_credentials_fileNoempty_stringPath to service account credentials file to use service account credentials

Was this page helpful?

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

0
Edit this page