# Dremio vs Vertica

**Leader by Vioscale score:** Dremio

| Attribute | Dremio | Vertica |
|---|---|---|
| **Vioscale score** | 72.1 (71% (medium)) | 24.5 (14% (low)) |
| deployment.options | `{"cloud":true,"self_hosted":true}` | `{"cloud":true,"hybrid":true,"on_prem":true,"self_hosted":true}` |
| description.long | An open-source lakehouse platform built on Apache Iceberg that enables data analytics and AI workloads with support for CDC, multi-source ingestion, and SQL-based querying. | A high-performance analytics platform built on columnar architecture and massively parallel processing that delivers real-time insights, machine learning, and fraud detection across on-premises, cloud, and hybrid deployments. Designed for enterprises to analyze massive volumes of data while maintaining flexibility in infrastructure choices. |
| features.capabilities | `{"deployment":"hybrid","sql_dialect":"vendor","architecture":"separated","license_class":"source_available","table_formats":"Apache Iceberg","semi_structured":"first_class","federation_query":true,"streaming_ingest":true}` | `{"in_db_ml":true,"deployment":"hybrid","sql_dialect":"vendor","architecture":"coupled_mpp","compute_model":"clusters","license_class":"proprietary","semi_structured":"first_class","streaming_ingest":true}` |
| integrations.count | 13 | - |
| integrations.list | `[{"name":"Apache Iceberg"},{"name":"Apache Polaris"},{"name":"dbt"},{"name":"PostgreSQL"},{"name":"MySQL"},{"name":"MongoDB"},{"name":"DynamoDB"},{"name":"Oracle"},{"name":"SQL Server"},{"name":"DB2"},{"name":"AWS EMR"},{"name":"AWS Glue"},{"name":"Apache Spark"}]` | - |
| platform.support | `{"cli":true,"web":true}` | - |
| pricing | `{"type":"consumption","plans":[{"free":false,"name":"Dremio Cloud","summary":"$0.20 per DCU. $400 credit free trial for 30 days.","features":["Fully managed infrastructure (AWS, Azure coming soon)","Automatic scaling and optimization","Automatic feature releases","Zero infrastructure management","AI Agent","AI Semantic Layer","Intelligent Query Engine","Open Catalog (Apache Polaris)","Enterprise-ready security"],"components":[{"per":{"qty":1,"unit":"DCU"},"kind":"metered","amount":0.2,"currency":"USD"}],"description":"Fully managed lakehouse on AWS with automatic scaling","contactSales":false},{"free":false,"name":"Dremio Enterprise","summary":"Consumption-based. Contact Sales for pricing.","features":["Self-managed on Kubernetes, on-premises, or cloud (AWS, Azure, GCP)","Full control over infrastructure, security, compliance","Flexible deployment options","AI Agent","AI Semantic Layer","Intelligent Query Engine","Open Catalog (Apache Polaris)","Enterprise-ready security","Manual scaling and updates"],"description":"Self-managed software with full control and customization","contactSales":true},{"free":true,"name":"Dremio Community Edition","summary":"Free, no time limit.","features":["Query engine"],"description":"Free query engine for local machines or servers","contactSales":false}],"summary":"From $0.20 per DCU. Free Community Edition. 30-day free trial.","currency":"USD","freeTier":true,"sourceUrl":"https://www.dremio.com","retrievedAt":"2026-08-03T12:40:05.170Z","freeTrialDays":30,"startingPrice":{"amount":0.2,"period":"month","currency":"USD"}}` | - |
| pricing.free_tier | yes | - |
| pricing.model | freemium | commercial |
| pricing.price_level | low | - |
| pricing.transparent | no | - |
| reliability.sla_pct | 99.99 | - |
| reliability.status_page | yes | - |
| security.disclosure_policy | yes | - |
| security.gdpr | yes | yes |
| security.hipaa | - | yes |
| security.iso27001 | yes | - |
| security.soc2 | yes | - |

## Capabilities (Data Warehouse Software)

| Capability | Dremio | Vertica |
|---|:--:|:--:|
| **Deployment** |  |  |
| Deployment | Hybrid | Hybrid |
| **Architecture** |  |  |
| Architecture | Separated storage/compute | Coupled MPP |
| Compute model | - | Clusters |
| **Query** |  |  |
| SQL dialect | Vendor-specific | Vendor-specific |
| Federation / lakehouse query-in-place | ✓ | - |
| **Interoperability** |  |  |
| Table-format support | Apache Iceberg | - |
| **Scale** |  |  |
| Concurrency scaling | - | - |
| **Ingestion** |  |  |
| Streaming ingest | ✓ | ✓ |
| **Data model** |  |  |
| Semi-structured (JSON/VARIANT) | First-class | First-class |
| **Analytics** |  |  |
| ML / in-DB functions | - | ✓ |
| **Sharing** |  |  |
| Data sharing / marketplace | - | - |
| **Licensing** |  |  |
| Licence class | Source-available | Proprietary |

*Source: Vioscale. Generated 2026-09-01T16:58:49.076Z. "-" = undocumented, not absent.*