Overview Quickstart CLI Commands .sql Models .py Models profiles.yml sources.yml Execution Paths

VERTICA

Columnar analytics database designed for large-scale data warehousing. Known for high-performance complex queries on massive datasets.

PREREQUISITES

Driver: vertica-python — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELD	TYPE	REQUIRED	DEFAULT	DESCRIPTION
type	string	yes	—	Must be `vertica`
host	string	yes	—	Vertica server hostname
port	integer	no	5433	Server port
user	string	yes	—	Database username
password	string	yes	—	Database password
database	string	yes	—	Database name
threads	integer	no	4	Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: vertica_dev
  outputs:
    vertica_dev:
      type: vertica
      host: vertica.internal.com
      port: 5433
      user: dbadmin
      password: "{{ env_var('VERTICA_PASSWORD') }}"
      database: analytics

SOURCES.YML EXAMPLE

sources:
  - name: enterprise_dw
    connection: vertica_dev
    database: warehouse
    tables:
      - name: sales_fact
      - name: customer_dim

INCREMENTAL STRATEGIES

✓ Append✓ Delete+Insert✓ Merge