Skip to main content

The vertica adapter plugin for dbt (data build tool)

Project description

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.)

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-vertica-0.18.0.tar.gz (7.9 kB view details)

Uploaded Source

Built Distribution

dbt_vertica-0.18.0-py3-none-any.whl (10.3 kB view details)

Uploaded Python 3

File details

Details for the file dbt-vertica-0.18.0.tar.gz.

File metadata

  • Download URL: dbt-vertica-0.18.0.tar.gz
  • Upload date:
  • Size: 7.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.6.0 requests/2.24.0 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.50.2 CPython/3.9.0

File hashes

Hashes for dbt-vertica-0.18.0.tar.gz
Algorithm Hash digest
SHA256 215f2b623b1fa3f4142be845130726ece554e978a7916f3e69ae2ff028ef716d
MD5 2f6b6f87eacdb63347a5d1c88d5a4352
BLAKE2b-256 704a80071e12369cfb2cb4a68fee7353b67ade87e56334ff49478df443826a27

See more details on using hashes here.

File details

Details for the file dbt_vertica-0.18.0-py3-none-any.whl.

File metadata

  • Download URL: dbt_vertica-0.18.0-py3-none-any.whl
  • Upload date:
  • Size: 10.3 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.6.0 requests/2.24.0 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.50.2 CPython/3.9.0

File hashes

Hashes for dbt_vertica-0.18.0-py3-none-any.whl
Algorithm Hash digest
SHA256 70a33e37a0681d4010f14cc2a699a53641b5ecdfe566ea9446b1733d90a3139f
MD5 1e5acae0b82b3689c88bc6e6ddc53d79
BLAKE2b-256 04be566265dcdd398453555e945d165166b5817e47dfe52043c3d726810b4614

See more details on using hashes here.

Supported by

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