dbt-vertica

Your dbt adapter for Vertica.

Built on dbt 0.18.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.)

Metadata

Release files for dbt-vertica 0.18.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for dbt-vertica 0.18.1
File	Size	Uploaded
dbt-vertica-0.18.1.tar.gz	7.9 kB	Nov 5, 2020	Details

Built distribution (wheel)

Table of built distributions (wheels) for dbt-vertica 0.18.1
File	Interpreter	ABI	Platform	Reset
dbt_vertica-0.18.1-py3-none-any.whl 10.3 kB Nov 5, 2020	Python 3	none	any	Details

Total release size: 18.2 kB

Release files / dbt-vertica-0.18.1.tar.gz

Download URL	dbt-vertica-0.18.1.tar.gz
Size	7.9 kB
Tags	Source
SHA-256 checksum How to use checksums	`5f47a1dcd9cdd6c49176380c1d0e65e6af0f70864d1b86092bd26edac607883e`
BLAKE2b-256 checksum How to use checksums	`c2dc5e51b98dc313a6546caa8cb17b56d4edcbba91f540d84e64115c2758e54d`
Upload date	Nov 5, 2020
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.2.0 pkginfo/1.6.1 requests/2.24.0 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.51.0 CPython/3.9.0`

Release files / dbt_vertica-0.18.1-py3-none-any.whl

Download URL	dbt_vertica-0.18.1-py3-none-any.whl
Size	10.3 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`856d7cd60d279317a4ec811910a34a64737e665453c3505cdeaf5cd21e8884ec`
BLAKE2b-256 checksum How to use checksums	`69a1523df37170e0c468bf8a76bab09bc8445df750d301e3b41f874b34c85714`
Upload date	Nov 5, 2020
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.2.0 pkginfo/1.6.1 requests/2.24.0 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.51.0 CPython/3.9.0`