Vertica integration

Vertica data, in your warehouse.

A built-in ingestr connector: add credentials, pick tables, schedule it.

name: raw.table
type: ingestr
parameters:
  source_connection: vertica
  source_table: '<table>'
  destination: snowflake
  incremental_strategy: merge

$ bruin run assets/raw/vertica.asset.yml

extract · Vertica dataincremental
load · snowflake raw.datamerged
checks · not_null, unique

Loaded and checked. Downstream models can run.

How it connects

Connected in three steps.

Vertica is a columnar, massively parallel processing (MPP) analytical database built for large-scale analytics, available on-premises, in the cloud, and as a free Community Edition. ingestr supports Vertica as both a source and a destination.

01
Add a Vertica connection with its credentials.
02
Pick the tables to load and how: replace, append or merge.
03
Bruin runs it on your schedule and checks every load.

Connection parameters

username: the Vertica user (required)
password: the password for the user
host: the Vertica hostname or IP address
port: the Vertica port (default: 5433)
database: the database to write into
tlsmode: TLS behavior — none (default, plaintext), prefer (TLS if the server supports it), server (TLS with CA verification), or server-strict (also verifies the hostname). Use tlsmode=server or tlsmode=server-strict over untrusted networks.
autocommit: 1 to enable (default) or 0 to disable autocommit.
usepreparedstatements: 1 to use server-side prepared statements (default) or 0 to disable them.
connectionloadbalance: 1 to let the server redirect the connection across nodes for load balancing (off by default).
backupservernode: a comma-separated list of host:port pairs to fail over to if the primary host is unreachable.

Every way Vertica works with Bruin

SourceBuilt-in ingestr sourceDocs →
DestinationBuilt-in ingestr destinationDocs →

The platform

Part of the Bruin platform.

Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.

See the full platform

01 · Move

Data Ingestion

02 · Model & govern

SQL & Python

Data Quality

Data Governance

03 · Use

AI Data Analyst

AI Dashboards

Data Apps

Self-Healing Pipelines

Bruin Cloudorchestration · governance · observability

Databases

More tools, same category.

All 71 Databases tools

PostgreSQL Built in MySQL Built in Microsoft SQL Server Built in MongoDB Built in Oracle Database Built in Amazon DynamoDB Built in Elasticsearch Built in SQLite Built in

Frequently asked

Questions about Vertica.

Does Bruin have a built-in Vertica integration?

Yes. Built-in ingestr source. Built-in ingestr destination.

Where can Vertica data go?

Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.

How fresh is the data?

As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.

Do we need Bruin Cloud?

No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.

Ready to connect Vertica?

$100 in credits and 50 AI tasks. No credit card.

Try for free

A demo walks through your own data.

Book a demo