Zeema
New design
Catalogue / data-warehouse

Vertica

Data warehousevertica

Columnar analytics database using projections, in Enterprise Mode or Eon Mode on communal storage.

Provider
default
Kind
Data warehouse
Category
Data
Official docs
https://docs.vertica.com/latest/en/architecture/
Properties · 3 set by this component
propertytypevaluesrequiredkind defaultthis component
communalStorage · component propertyboolean—nofalseinherited
formatenumcolumnar | rownocolumnar▸ columnar
managedboolean—nofalse▸ false
mode · component propertyenumenterprise | eonnoenterpriseinherited
realtimeboolean—nofalse▸ false
upsertboolean—nofalseinherited
Rules that apply · 0

Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.

No rule reads this kind yet. That is a gap, not a guarantee.
Use it in a design
nodes:
  - { id: "vertica", component: "vertica" }
Other Data warehouse products · 39
AnalyticDBalibaba-analyticdbalibabaclouddata-warehouseApsaraDB for ClickHousealibaba-clickhousealibabaclouddata-warehouseHologresalibaba-hologresalibabaclouddata-warehouseMaxComputealibaba-maxcomputealibabaclouddata-warehouseApsaraDB for SelectDBalibaba-selectdbalibabaclouddata-warehouseAmazon Athenaaws-athenaawsdata-warehouseAmazon Redshiftredshiftawsdata-warehouseAzure Analysis Servicesazure-analysis-servicesazuredata-warehouseMicrosoft Fabricazure-fabricazuredata-warehouseAzure Synapse Analyticsazure-synapseazuredata-warehouseR2 SQLcloudflare-r2-sqlcloudflaredata-warehouseClickHouseclickhousedata-warehouseGeneric data warehousedata-warehousedata-warehouseDatabricks SQLdatabricks-sqldata-warehouseApache Dorisdorisdata-warehouseDremiodremiodata-warehouseApache Drilldrilldata-warehouseApache Druiddruiddata-warehouseDuckDBduckdbdata-warehouseExasolexasoldata-warehouseFireboltfireboltdata-warehouseGreenplumgreenplumdata-warehouseApache Hivehivedata-warehouseApache Impalaimpaladata-warehouseApache Kylinkylindata-warehouseMonetDBmonetdbdata-warehouseMotherDuckmotherduckdata-warehouseApache Pinotpinotdata-warehousePrestoprestodata-warehouseSnowflakesnowflakedata-warehouseStarRocksstarrocksdata-warehouseTeradata Vantageteradatadata-warehouseTrinotrinodata-warehouseGoogle BigQuerybigquerygcpdata-warehouseDb2 Warehouse as a Serviceibm-db2-warehouseibmdata-warehouseNetezza Performance Server as a Serviceibm-netezzaibmdata-warehouseIBM watsonx.dataibm-watsonx-dataibmdata-warehouseAutonomous AI Lakehouseoci-autonomous-data-warehouseocidata-warehouseMySQL HeatWave clusteroci-mysql-heatwave-clusterocidata-warehouse
Source
# yaml-language-server: $schema=../../schema/component.schema.json
# Vertica: self-managed columnar analytics database. "Architecture": data is stored in column
# format and physically laid out as projections that are distributed and replicated across nodes;
# Enterprise Mode keeps data on the nodes while Eon Mode separates compute from communal object storage.
schemaVersion: "1"
type: "component"
id: "vertica"
kind: "data-warehouse"
provider: "default"
docs: "https://docs.vertica.com/latest/en/architecture/"
defaults:
  realtime: false
  format: "columnar"
  managed: false
properties:
  mode:
    type: "enum"
    values: ["enterprise", "eon"]
    default: "enterprise"
  communalStorage:
    type: "boolean"
    default: false

The same page as markdown, for an agent: /catalogue/components/vertica.md