dbt adapter for IBM db2 for i
Project description
dbt-db2fori
A dbt adapter for IBM's DB2 for i v7.2+. The connection to the warehouse is through ODBC
and requires that pyodbc
is installed. All credits to dbt-sqlserver adapter and dbt-ibmdb2 projects that heavily inspired this adapter.
Why this adapter?
A similar adapter dbt-ibmdb2 exists, however, dbt-ibmdb2 uses the ibm_db
Python package to connect to IBM DB2. This adapter connects to the warehouse using pyodbc
.
Features
The following materializations are supported:
- Incremental
- Snapshot
- View
- Table
- Seed
Ephemeral models have not been tested yet.
Installation
Use pip to install:
pip install dbt-db2fori
An example profiles.yml
is:
default:
outputs:
dev:
type: db2_for_i
threads: 4
driver: IBM i Access ODBC Driver
system: system
username: "{{ env_var('USER_NAME') }}"
password: "{{ env_var('PASSWORD') }}"
database: db
schema: schema
target: dev
To report a bug or request a feature, open an issue
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
dbt_db2fori-1.7.9.tar.gz
(18.1 kB
view hashes)
Built Distribution
Close
Hashes for dbt_db2fori-1.7.9-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 11d8d741132a9ad6d46a2609843349019f10688e20e0ff976df914efba3cdbb6 |
|
MD5 | 30bd28e5fddb56fa3c3f86d58e24d591 |
|
BLAKE2b-256 | d59582154b7673f1930c4a73fd10ff6baa8365baf1c6c3a5264740aba495637f |