Teradata Vantage

Shared-nothing MPP analytics platform distributing rows by primary index across AMPs.

Provider: default
Kind: Data warehouse
Category: Data
Official docs: https://docs.teradata.com/r/Enterprise_IntelliFlex_VMware/Database-Design/Primary-Index-Primary-AMP-Index-and-NoPI-Objects/Column-Partitioning

Properties · 3 set by this component

property	type	values	required	kind default	this component
columnPartitioning · component property	boolean	—	no	false	inherited
deployment · component property	enum	on-premises \| vantagecloud-enterprise \| vantagecloud-lake	no	—	inherited
distribution · component property	enum	primary-index-hash \| no-primary-index	no	primary-index-hash	inherited
format	enum	columnar \| row	no	columnar	▸ row
managed	boolean	—	no	false	▸ false
realtime	boolean	—	no	false	▸ false
upsert	boolean	—	no	false	inherited

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: "teradata", component: "teradata" }

Other Data warehouse products · 39

AnalyticDBalibaba-analyticdbalibabaclouddata-warehouse ApsaraDB for ClickHousealibaba-clickhousealibabaclouddata-warehouse Hologresalibaba-hologresalibabaclouddata-warehouse MaxComputealibaba-maxcomputealibabaclouddata-warehouse ApsaraDB for SelectDBalibaba-selectdbalibabaclouddata-warehouse Amazon Athenaaws-athenaawsdata-warehouse Amazon Redshiftredshiftawsdata-warehouse Azure Analysis Servicesazure-analysis-servicesazuredata-warehouse Microsoft Fabricazure-fabricazuredata-warehouse Azure Synapse Analyticsazure-synapseazuredata-warehouse R2 SQLcloudflare-r2-sqlcloudflaredata-warehouse ClickHouseclickhousedata-warehouse Generic data warehousedata-warehousedata-warehouse Databricks SQLdatabricks-sqldata-warehouse Apache Dorisdorisdata-warehouse Dremiodremiodata-warehouse Apache Drilldrilldata-warehouse Apache Druiddruiddata-warehouse DuckDBduckdbdata-warehouse Exasolexasoldata-warehouse Fireboltfireboltdata-warehouse Greenplumgreenplumdata-warehouse Apache Hivehivedata-warehouse Apache Impalaimpaladata-warehouse Apache Kylinkylindata-warehouse MonetDBmonetdbdata-warehouse MotherDuckmotherduckdata-warehouse Apache Pinotpinotdata-warehouse Prestoprestodata-warehouse Snowflakesnowflakedata-warehouse StarRocksstarrocksdata-warehouse Trinotrinodata-warehouse Verticaverticadata-warehouse Google BigQuerybigquerygcpdata-warehouse Db2 Warehouse as a Serviceibm-db2-warehouseibmdata-warehouse Netezza Performance Server as a Serviceibm-netezzaibmdata-warehouse IBM watsonx.dataibm-watsonx-dataibmdata-warehouse Autonomous AI Lakehouseoci-autonomous-data-warehouseocidata-warehouse MySQL HeatWave clusteroci-mysql-heatwave-clusterocidata-warehouse

Source

1# yaml-language-server: $schema=../../schema/component.schema.json
2# Teradata Vantage: shared-nothing MPP analytics platform. Architecture docs: parsing engines,
3# BYNET and AMPs, with rows hash-distributed by primary index to each AMP's virtual disk.
4# "Column partitioning": storing a table by column instead of by row is an opt-in Teradata Columnar feature.
5schemaVersion: "1"
6type: "component"
7id: "teradata"
8kind: "data-warehouse"
9provider: "default"
10docs: "https://docs.teradata.com/r/Enterprise_IntelliFlex_VMware/Database-Design/Primary-Index-Primary-AMP-Index-and-NoPI-Objects/Column-Partitioning"
11defaults:
12  realtime: false
13  format: "row"
14  managed: false
15properties:
16  columnPartitioning:
17    type: "boolean"
18    default: false
19  deployment:
20    type: "enum"
21    values: ["on-premises", "vantagecloud-enterprise", "vantagecloud-lake"]
22  distribution:
23    type: "enum"
24    values: ["primary-index-hash", "no-primary-index"]
25    default: "primary-index-hash"

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