The vertica adapter plugin for dbt (data build tool)
Built on dbt 0.15.x
Uses vertica-python to connect to Vertica database.
pip install dbt-vertica
You don't need to install dbt separately. Installing
dbt-vertica will also install
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
dbt-vertica will request
ConnectionLoadBalance=true (which is generally a good thing), and set a session label of
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.)
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size dbt_vertica-0.15.0-py3-none-any.whl (10.3 kB)||File type Wheel||Python version py3||Upload date||Hashes View|
|Filename, size dbt-vertica-0.15.0.tar.gz (8.0 kB)||File type Source||Python version None||Upload date||Hashes View|
Hashes for dbt_vertica-0.15.0-py3-none-any.whl