dbt-ydb 0.0.3

DBT adapter for YDB

dbt-ydb

dbt-ydb is a plugin for dbt that provides support for working with YDB.

Installation

To install plugin, execute the following command:

pip install dbt-ydb

Supported features

• Table materialization
• View materialization
• Seeds
• Docs generate
• Tests
• Incremental materializations
• Snapshots

Usage

Profile Configuration

To configure YDB connection, fill profile.yml file as below:

profile_name:
  target: dev
  outputs:
    dev:
      type: ydb
      host: [localhost] # YDB host
      port: [2136] # YDB port
      database: [/local] # YDB database
      schema: [<empty string>] # Optional subfolder for DBT models
      secure: [False] # If enabled, grpcs protocol will be used
      root_certificates_path: [<empty string>] # Optional path to root certificates file

      # Static Credentials
      username: [<empty string>]
      password: [<empty string>]

      # Access Token Credentials
      token: [<empty string>]

      # Service Account Credentials
      service_account_credentials_file: [<empty string>]

Model Configuration

View

Option	Description	Required	Default

Table

Option	Description	Required	Default
primary_key	Primary key to use during table creation	yes
store_type	Type of table. Available options are row and column	no	row

Seed

Option	Description	Required	Default
primary_key	Primary key to use during table creation	no	The first column of CSV will be used as default.

Limitations

• YDB does not support CTE