The vertica adapter plugin for dbt (data build tool)
Project description
dbt-vertica
Built on dbt 0.15.x
Uses vertica-python to connect to Vertica database.
Install
pip install dbt-vertica
You don't need to install dbt separately. Installing dbt-vertica will also install dbt-core and vertica-python.
Sample Profile Configuration
your-profile:
outputs:
dev:
type: vertica # Don't change this!
host: vertica-host-name
port: 5433 # or your custom port (optional)
username: your-username
password: your-password
database: vertica-database-name
schema: your-default-schema
target: dev
By default, dbt-vertica will request ConnectionLoadBalance=true (which is generally a good thing), and set a session label of dbt_your-username.
Reach out!
First off, I would not have been able to make this adapater if the smart folks at Fishtown Analytics didn't make it so easy. That said, it seems every database has its own little quirks. I ran into several different issues when adapting the macros to Vertica. If you find something not working right, please open an issue (assuming it has to do with the adapter and not dbt itself).
Also, I would be excited to hear about anyone who is able to benefit from using dbt with Vertica. (Just open an issue to leave me a comment.)
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
Built Distribution
Hashes for dbt_vertica-0.15.0-py3-none-any.whl
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | c5efc987cb10a8afafbeddd77de6350a523a28fffa8a48a1754c2f637df00ebd |
|
| MD5 | bba16061f59101247b26c925df8ca763 |
|
| BLAKE2b-256 | c8160742c9184effac9235f63cc1dfab4383a0884ae86b0bb44379f9ac84c8b6 |
