# DuckDB vs Teradata

**Leader by vioscaleAI score:** DuckDB

| Attribute | DuckDB | Teradata |
|---|---|---|
| **vioscaleAI score** | 59.1 (51% (medium)) | 34.6 (33% (low)) |
| activity.commits_last_30d | 100 | - |
| adoption.dependent_repos | 1 | - |
| adoption.github_stars | 42,154 | - |
| adoption.package_downloads_weekly | 15,285,415 | - |
| content.faq | `[{"answer":"An in-process SQL analytical database that runs natively in applications across operating systems and environments. Supports querying files and cloud data directly with a SQL dialect and includes vector search capabilities. It is indexed under Data Warehouse Software.","source":"https://duckdb.org","question":"What is DuckDB?","confidence":0.6},{"answer":"DuckDB is open source, so it can be self-hosted and used at no licence cost. It is released under the MIT licence. Pricing changes often, so verify at source before relying on it.","source":"https://duckdb.org","question":"Is DuckDB free to use?","confidence":0.6},{"answer":"DuckDB supports the web, Windows, macOS, Linux and a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://duckdb.org","question":"What platforms does DuckDB support?","confidence":0.6},{"answer":"Yes. DuckDB can be deployed self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://duckdb.org","question":"Can DuckDB be self-hosted?","confidence":0.6},{"answer":"We have confirmed 27 integrations for DuckDB, including Postgres, AWS, S3, Azure, Google Cloud, Hugging Face, SQLite and MySQL, plus 19 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://duckdb.org","question":"What does DuckDB integrate with?","confidence":0.6},{"answer":"Yes. DuckDB is published under the MIT licence, a permissive licence that generally allows commercial use and modification. Licence terms can change between releases, so verify against the repository for the version you intend to use.","source":"https://github.com/duckdb/duckdb","question":"Is DuckDB open source?","confidence":0.99},{"answer":"DuckDB is available worldwide. The vendor is headquartered in the Netherlands.","source":"https://duckdb.org","question":"Where is DuckDB available?","confidence":0.75}]` | `[{"answer":"A data platform that enables organizations to ingest, transform, and analyze structured and unstructured data, then build AI agents and applications on top with enterprise governance, security, and scale across cloud, on-premises, or hybrid environments. It is indexed under Data Warehouse Software.","source":"https://www.teradata.com","question":"What is Teradata?","confidence":0.6},{"answer":"Teradata is a paid product; published pricing starts at $4.80. It is sold across 3 plans (Standard, VantageCloud Lake and VantageCloud Lake+). There is no free tier. Prices are published openly on the vendor's own pricing page. Pricing changes often, so verify at source before relying on it.","source":"https://www.teradata.com","question":"How much does Teradata cost?","confidence":0.6},{"answer":"We have confirmed browser-based access to Teradata. That is the extent of what we could verify from public sources, so it may well offer desktop or mobile clients we have not indexed.","source":"https://www.teradata.com/pricing/workload-comparisons/migrate-to-teradata-offer","question":"What platforms does Teradata support?","confidence":0.6},{"answer":"Yes. Teradata can be deployed cloud / SaaS, hybrid and on-premise, so it does not have to run on the vendor's infrastructure.","source":"https://www.teradata.com","question":"Can Teradata be self-hosted?","confidence":0.6},{"answer":"We have confirmed 10 integrations for Teradata, including dbt, Apache Airflow, Dagster, Airbyte, Trino, Python, Node.js and JDBC, plus 2 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://www.teradata.com","question":"What does Teradata integrate with?","confidence":0.6}]` |
| deployment.options | `{"self_hosted":true}` | `{"cloud":true}` |
| description.long | A portable analytical database that runs locally or embedded in applications, with PostgreSQL-like SQL and APIs for major programming languages, supporting popular data formats including CSV, JSON, Parquet, and Apache Iceberg. | Teradata is a cloud-based enterprise data platform that enables organizations to build and operate AI agents on governed data, providing advanced analytics, query optimization, and significantly reduced operational costs compared to competing platforms. |
| features.capabilities | `{"in_db_ml":true,"deployment":"embedded","sql_dialect":"vendor","license_class":"permissive","table_formats":"Parquet, CSV, JSON, Iceberg, Delta Lake, Vortex, DuckLake, Lance, Arrow, Avro, E","semi_structured":"functional","federation_query":true}` | `{"in_db_ml":true,"deployment":"hybrid","sql_dialect":"vendor","semi_structured":"first_class","concurrency_scaling":"automatic"}` |
| integrations.count | 27 | 11 |
| integrations.list | `[{"name":"Postgres"},{"name":"AWS"},{"name":"S3"},{"name":"Azure"},{"name":"Google Cloud"},{"name":"Hugging Face"},{"name":"SQLite"},{"name":"MySQL"},{"name":"Iceberg"},{"name":"Delta Lake"},{"name":"Parquet"},{"name":"JSON"},{"name":"Arrow"},{"name":"Avro"},{"name":"Pandas"},{"name":"dplyr"},{"name":"Jupyter"},{"name":"Marimo"},{"name":"Claude"},{"name":"Cloudflare"},{"name":"ODBC"},{"name":"HTTP"},{"name":"Excel"},{"name":"Vortex"},{"name":"DuckLake"},{"name":"Lance"},{"name":"Geospatial formats"},{"name":"PostgreSQL","category":"database"},{"name":"Apache Iceberg","category":"table_format"},{"name":"ADBC","native":true}]` | `[{"name":"dbt","native":true,"category":"analytics","direction":"bidirectional"},{"name":"Apache Airflow","category":"orchestration"},{"name":"Dagster","category":"orchestration"},{"name":"Airbyte","category":"data_integration"},{"name":"Trino","category":"query_engine"},{"name":"Python"},{"name":"R"},{"name":"Node.js"},{"name":"JDBC"},{"name":"REST API"},{"name":"Jupyter"},{"name":"Salesforce","category":"crm"},{"name":"ServiceNow"}]` |
| language.primary | C++ | - |
| license.spdx | MIT | - |
| market.availability | `{"hqCountry":"NL","primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | `{"primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` |
| platform.support | `{"cli":true,"mac":true,"linux":true,"windows":true}` | `{"web":true}` |
| pricing | `{"type":"open_source","summary":"Free, open source under MIT license","freeTier":true,"sourceUrl":"https://duckdb.org","retrievedAt":"2026-08-14T15:30:03.636Z"}` | `{"type":"consumption","plans":[{"free":false,"name":"Standard","summary":"From $4.80/hour compute (U.S. region only)","features":["Teradata Engine","Premier Cloud Support"],"components":[{"per":{"qty":1,"unit":"hour"},"kind":"metered","amount":4.8,"currency":"USD"}],"contactSales":false},{"free":false,"name":"VantageCloud Lake","summary":"From $6.00/hour compute (U.S. region only)","features":["Teradata Engine"],"components":[{"per":{"qty":1,"unit":"hour"},"kind":"metered","amount":6,"currency":"USD"}],"contactSales":false},{"free":false,"name":"VantageCloud Lake+","summary":"From $7.20/hour compute (U.S. region only)","features":["Teradata Engine","Priority Service"],"components":[{"per":{"qty":1,"unit":"hour"},"kind":"metered","amount":7.2,"currency":"USD"}],"contactSales":false}],"addOns":[{"name":"Block Storage","components":[{"per":{"qty":1,"unit":"TB"},"kind":"metered","amount":1445,"currency":"USD"}]},{"name":"Object Storage","components":[{"per":{"qty":1,"unit":"TB"},"kind":"metered","amount":276,"currency":"USD"}]}],"summary":"Consumption-based pricing: from $4.80/hour compute + storage from $276/TB/year (object storage). On-demand and commitment options. Pricing for U.S. region; data transfer charged separately.","currency":"USD","freeTier":false,"sourceUrl":"https://www.teradata.com","retrievedAt":"2026-08-03T12:43:20.309Z","startingPrice":{"amount":4.8,"period":"month","currency":"USD"},"billingPeriods":["month","year"]}` |
| pricing.free_tier | yes | no |
| pricing.model | open_source | commercial |
| pricing.price_level | free | unknown |
| pricing.transparent | yes | no |
| release.cadence_days | 33 | - |
| release.history | `[{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.6","date":"2026-09-28T13:35:11Z","type":"stable","version":"v1.5.6"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.5","date":"2026-07-22T10:51:50Z","type":"stable","version":"v1.5.5"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.4","date":"2026-06-17T10:45:53Z","type":"stable","version":"v1.5.4"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.5","date":"2026-06-17T10:42:38Z","type":"stable","version":"v1.4.5"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.3","date":"2026-05-20T11:50:43Z","type":"stable","version":"v1.5.3"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.2","date":"2026-04-13T10:46:51Z","type":"stable","version":"v1.5.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.1","date":"2026-03-23T12:10:58Z","type":"stable","version":"v1.5.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.5.0","date":"2026-03-09T12:40:59Z","type":"stable","version":"v1.5.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.4","date":"2026-01-26T12:08:09Z","type":"stable","version":"v1.4.4"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.3","date":"2025-12-09T10:20:40Z","type":"stable","version":"v1.4.3"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.2","date":"2025-11-12T13:04:29Z","type":"stable","version":"v1.4.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.1","date":"2025-10-07T10:29:57Z","type":"stable","version":"v1.4.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.4.0","date":"2025-09-16T10:17:31Z","type":"stable","version":"v1.4.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.3.2","date":"2025-07-08T10:39:09Z","type":"stable","version":"v1.3.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.3.1","date":"2025-06-16T13:54:58Z","type":"stable","version":"v1.3.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.3.0","date":"2025-05-21T16:04:19Z","type":"stable","version":"v1.3.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.2.2","date":"2025-04-08T08:44:15Z","type":"stable","version":"v1.2.2"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.2.1","date":"2025-03-05T18:03:02Z","type":"stable","version":"v1.2.1"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.2.0","date":"2025-02-05T13:57:07Z","type":"stable","version":"v1.2.0"},{"url":"https://github.com/duckdb/duckdb/releases/tag/v1.1.3","date":"2024-11-04T13:59:58Z","type":"stable","version":"v1.1.3"}]` | - |
| reliability.status_page | yes | - |
| security.disclosure_policy | - | yes |
| security.gdpr | - | yes |
| security.hipaa | - | yes |
| security.trust_center | - | https://www.teradata.com/trusted-ai |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=conda&package_name=python-duckdb&per_page=100","last_12m":0,"max_severity":null}` | - |

## Capabilities (Data Warehouse Software)

| Capability | DuckDB | Teradata |
|---|:--:|:--:|
| **Deployment** |  |  |
| Deployment | Embedded | Hybrid |
| **Architecture** |  |  |
| Architecture | - | - |
| Compute model | - | - |
| **Query** |  |  |
| SQL dialect | Vendor-specific | Vendor-specific |
| Federation / lakehouse query-in-place | ✓ | - |
| **Interoperability** |  |  |
| Table-format support | Parquet, CSV, JSON, Iceberg, Delta Lake, Vortex, DuckLake, Lance, Arrow, Avro, E | - |
| **Scale** |  |  |
| Concurrency scaling | - | Automatic |
| **Ingestion** |  |  |
| Streaming ingest | - | - |
| **Data model** |  |  |
| Semi-structured (JSON/VARIANT) | Functional | First-class |
| **Analytics** |  |  |
| ML / in-DB functions | ✓ | ✓ |
| **Sharing** |  |  |
| Data sharing / marketplace | - | - |
| **Licensing** |  |  |
| Licence class | Permissive OSS | - |

*Source: vioscaleAI. Generated 2026-10-16T20:10:25.400Z. "-" = undocumented, not absent.*