Skip to main content

The db2 adapter plugin for dbt (data build tool)

Project description

pypi python

dbt-ibmdb2

This plugin ports dbt functionality to IBM DB2.

This is an experimental plugin:

  • We have not tested it extensively
  • Only basic tests are implemented
  • Compatibility with other dbt packages (like dbt_utils) is only partially tested

Please read these docs carefully and use at your own risk. Issues welcome!

Table of Contents

Installation

This plugin can be installed via pip:

$ pip install dbt-ibmdb2

Supported features

DB2 LUW DB2 z/OS Feature
🤷 Table materialization
🤷 View materialization
🤷 Incremental materialization
🤷 Ephemeral materialization
🤷 Seeds
🤷 Sources
🤷 Custom data tests
🤷 Docs generate
🤷 Snapshots

Notes:

  • dbt-ibmdb2 is built on the ibm_db python package and there are some known encoding issues related to z/OS.

Configuring your profile

A dbt profile can be configured to run against DB2 using the following configuration example:

Example entry for profiles.yml:

your_profile_name:
  target: dev
  outputs:
    dev:
      type: ibmdb2
      schema: analytics
      database: test
      host: localhost
      port: 50000
      protocol: TCPIP
      user: my_username
      password: my_password
      extra_connect_opts: my_extra_config_options
Option Description Required? Example
type The specific adapter to use Required ibmdb2
schema Specify the schema (database) to build models into Required analytics
database Specify the database you want to connect to Required testdb
host Hostname or IP-adress Required localhost
port The port to use Optional 50000
protocol Protocol to use Optional TCPIP
user The username to use to connect to the server Required my-username
password The password to use for authenticating to the server Required my-password
extra_connect_opts Extra connection options Optional Security=SSL;SSLClientKeyStoreDB=<path-to-client-keystore>;SSLClientKeyStash=<path-to-client-keystash>

Setup dev environment and run tests

Make sure you have docker and poetry installed globally.

make install
make test
make uninstall

Reporting bugs

Want to report a bug or request a feature? Open an issue.

Credits

dbt-ibmdb2 is heavily inspired by and borrows from dbt-mysql and dbt-oracle.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbt_ibmdb2-1.4.4.tar.gz (17.1 kB view details)

Uploaded Source

Built Distribution

dbt_ibmdb2-1.4.4-py3-none-any.whl (23.0 kB view details)

Uploaded Python 3

File details

Details for the file dbt_ibmdb2-1.4.4.tar.gz.

File metadata

  • Download URL: dbt_ibmdb2-1.4.4.tar.gz
  • Upload date:
  • Size: 17.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.8.2 CPython/3.9.18 Linux/6.5.0-1015-azure

File hashes

Hashes for dbt_ibmdb2-1.4.4.tar.gz
Algorithm Hash digest
SHA256 d556bfc0d11e9aa1cab5471b29ed378c438344f48444e5d0ffcb650afe129e6d
MD5 f6aeec552ccd53ab73a88a1d2ca144a2
BLAKE2b-256 e2e44551aba86aaa57a465107d25560347500f761338dbb235af42e465f7c8a5

See more details on using hashes here.

File details

Details for the file dbt_ibmdb2-1.4.4-py3-none-any.whl.

File metadata

  • Download URL: dbt_ibmdb2-1.4.4-py3-none-any.whl
  • Upload date:
  • Size: 23.0 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.8.2 CPython/3.9.18 Linux/6.5.0-1015-azure

File hashes

Hashes for dbt_ibmdb2-1.4.4-py3-none-any.whl
Algorithm Hash digest
SHA256 b02ac1ee9443a864ffc9fe0079ad1d88f629fdd24730e0dd078b7942b973de8d
MD5 2ab9bdceb287d15df16783c268e24414
BLAKE2b-256 10d3535111be169de07e98b5be48533c408258f0acd08c458022e7a8a86471e2

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page