Skip to main content

Vertica setup

Community plugin

Some core functionality may be limited. If you're interested in contributing, check out the source code for each repository listed below.

Overview of dbt-vertica

  • Maintained by: Community
  • Authors: Matthew Carter, Andy Regan, Andrew Hedengren
  • GitHub repo: mpcarter/dbt-vertica
  • PyPI package: dbt-vertica
  • Slack channel: n/a
  • Supported dbt Core version: v0.21.0 and newer
  • dbt Cloud support: Not Supported
  • Minimum data platform version: Vertica 10.0

Installing dbt-vertica

pip is the easiest way to install the adapter:

pip install dbt-vertica

Installing dbt-vertica will also install dbt-core and any other dependencies.

Configuring dbt-vertica

For Vertica-specifc configuration please refer to Vertica Configuration

For further info, refer to the GitHub repository: mpcarter/dbt-vertica

Connecting to Vertica with dbt-vertica

Username / password authentication

Configure your dbt profile for using Vertica:

Vertica connection information
profiles.yml
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.

There are three options for SSL: ssl, ssl_env_cafile, and ssl_uri. See their use in the code here.

0