# Amazon Redshift vs Dremio

**Leader by Vioscale score:** Dremio

| Attribute | Amazon Redshift | Dremio |
|---|---|---|
| **Vioscale score** | 55 (73% (medium)) | 72.1 (71% (medium)) |
| deployment.options | `{"cloud":true}` | `{"cloud":true,"self_hosted":true}` |
| description.long | A cloud-based data warehouse available in provisioned and serverless deployment models, supporting SQL analytics across data warehouses and data lakes. Redshift integrates with SageMaker for AI workloads and connects to S3 and third-party data sources via zero-ETL integrations. | 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. |
| features.capabilities | `{"in_db_ml":true,"deployment":"managed","sql_dialect":"vendor","architecture":"separated","data_sharing":true,"compute_model":"clusters","license_class":"proprietary","table_formats":"Iceberg, Parquet","semi_structured":"functional","federation_query":true,"streaming_ingest":true,"concurrency_scaling":"automatic"}` | `{"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}` |
| integrations.count | 7 | 13 |
| integrations.list | `[{"name":"Amazon S3"},{"name":"Amazon SageMaker"},{"name":"Amazon Bedrock"},{"name":"Apache Iceberg"},{"name":"Apache Parquet"},{"name":"Streaming services"},{"name":"Operational databases"}]` | `[{"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"}]` |
| market.availability | `{"hqCountry":"US","primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | - |
| platform.support | `{"cli":true,"web":true}` | `{"cli":true,"web":true}` |
| pricing | `{"type":"hybrid","plans":[{"free":false,"name":"Provisioned On-Demand","features":["Flexible scaling","Pause and resume","Node type selection","Elastic Resize"],"commitment":"monthly","components":[{"kind":"fixed","amount":0.543,"period":"hour","currency":"USD"}],"description":"Hourly billing for provisioned clusters with no long-term commitments; can pause/resume to avoid charges","contactSales":false},{"free":false,"name":"Provisioned Reserved Instances","features":["Significant discounts over on-demand","Steady-state workloads","Cost predictability"],"commitment":"annual","description":"Discounted pricing for reserved capacity with annual or multi-year commitment","contactSales":false},{"free":false,"name":"Serverless","features":["Automatic capacity scaling","No idle charges","Seconds-based billing","Automatic shutdown"],"components":[{"per":{"qty":1,"unit":"hour"},"kind":"metered","amount":1.5,"currency":"USD"}],"description":"Per-second billing with automatic scaling; no compute charges during idle periods","contactSales":false},{"free":false,"name":"Serverless Reservations","features":["Up to 45% savings on Serverless compute","Cross-account sharing","AWS payer account management"],"commitment":"annual","description":"Discounted Serverless rates; shareable across AWS accounts at the payer account level","contactSales":false}],"addOns":[{"name":"Redshift Managed Storage (RMS)"},{"name":"Concurrency Scaling"},{"name":"Redshift Spectrum"},{"name":"Redshift ML"}],"summary":"Provisioned from $0.543/hour on-demand or discounted reserved rates; Serverless from $1.50/hour per-second billing. Free $300 credit for 90 days on new Serverless accounts.","currency":"USD","freeTier":true,"sourceUrl":"https://aws.amazon.com/redshift/pricing/","retrievedAt":"2026-08-14T15:27:34.606Z","freeTrialDays":90,"startingPrice":{"amount":0.543,"period":"month","currency":"USD"},"billingPeriods":["month","hour","second"]}` | `{"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 | yes |
| pricing.model | freemium | freemium |
| pricing.price_level | low | low |
| pricing.transparent | yes | no |
| reliability.sla_pct | - | 99.99 |
| reliability.status_page | yes | yes |
| security.disclosure_policy | yes | yes |
| security.fedramp | yes | - |
| security.gdpr | yes | yes |
| security.hipaa | yes | - |
| security.iso27001 | - | yes |
| security.pci | yes | - |
| security.soc2 | - | yes |

## Capabilities (Data Warehouse Software)

| Capability | Amazon Redshift | Dremio |
|---|:--:|:--:|
| **Deployment** |  |  |
| Deployment | Managed cloud | Hybrid |
| **Architecture** |  |  |
| Architecture | Separated storage/compute | Separated storage/compute |
| Compute model | Clusters | - |
| **Query** |  |  |
| SQL dialect | Vendor-specific | Vendor-specific |
| Federation / lakehouse query-in-place | ✓ | ✓ |
| **Interoperability** |  |  |
| Table-format support | Iceberg, Parquet | Apache Iceberg |
| **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 | Proprietary | Source-available |

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