# Amazon Redshift vs Presto

| Attribute | Amazon Redshift | Presto |
|---|---|---|
| **Vioscale score** | 55 (73% (medium)) | 54.6 (33% (low)) |
| activity.commits_last_30d | - | 100 |
| adoption.dependent_repos | - | 441 |
| adoption.github_stars | - | 16,724 |
| deployment.options | `{"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. | The fastest open-source SQL query engine for modern data analytics at scale. Enables querying massive datasets across multiple data sources with sub-second performance. |
| 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":"self","sql_dialect":"ansi","architecture":"separated","license_class":"permissive","semi_structured":"functional","federation_query":true}` |
| integrations.count | 7 | - |
| integrations.list | `[{"name":"Amazon S3"},{"name":"Amazon SageMaker"},{"name":"Amazon Bedrock"},{"name":"Apache Iceberg"},{"name":"Apache Parquet"},{"name":"Streaming services"},{"name":"Operational databases"}]` | - |
| language.primary | - | Java |
| license.spdx | - | Apache-2.0 |
| market.availability | `{"hqCountry":"US","primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | - |
| platform.support | `{"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":"open_source","summary":"Free and open source","freeTier":true,"sourceUrl":"https://prestodb.io","retrievedAt":"2026-08-03T12:41:36.983Z"}` |
| pricing.free_tier | yes | yes |
| pricing.model | freemium | commercial |
| pricing.price_level | low | free |
| pricing.transparent | yes | - |
| release.cadence_days | - | 47 |
| release.history | - | `[{"url":"https://github.com/prestodb/presto/releases/tag/0.298.1","date":"2026-06-17T16:41:32Z","type":"stable","version":"0.298.1"},{"url":"https://github.com/prestodb/presto/releases/tag/0.298","date":"2026-06-12T18:46:43Z","type":"stable","version":"0.298"},{"url":"https://github.com/prestodb/presto/releases/tag/0.297","date":"2026-04-14T01:39:14Z","type":"stable","version":"0.297"},{"url":"https://github.com/prestodb/presto/releases/tag/0.296","date":"2025-12-08T18:33:56Z","type":"stable","version":"0.296"},{"url":"https://github.com/prestodb/presto/releases/tag/0.295","date":"2025-10-15T07:54:22Z","type":"stable","version":"0.295"},{"url":"https://github.com/prestodb/presto/releases/tag/0.294","date":"2025-08-27T18:59:30Z","type":"stable","version":"0.294"},{"url":"https://github.com/prestodb/presto/releases/tag/0.293","date":"2025-08-28T21:44:31Z","type":"stable","version":"0.293"},{"url":"https://github.com/prestodb/presto/releases/tag/0.292","date":"2025-08-28T21:44:27Z","type":"stable","version":"0.292"},{"url":"https://github.com/prestodb/presto/releases/tag/0.291","date":"2025-08-28T21:44:22Z","type":"stable","version":"0.291"},{"url":"https://github.com/prestodb/presto/releases/tag/0.290","date":"2025-08-28T21:44:18Z","type":"stable","version":"0.290"},{"url":"https://github.com/prestodb/presto/releases/tag/0.289","date":"2025-08-28T21:44:13Z","type":"stable","version":"0.289"},{"url":"https://github.com/prestodb/presto/releases/tag/0.288","date":"2025-08-28T21:44:08Z","type":"stable","version":"0.288"},{"url":"https://github.com/prestodb/presto/releases/tag/0.287","date":"2025-08-28T21:44:04Z","type":"stable","version":"0.287"},{"url":"https://github.com/prestodb/presto/releases/tag/0.286","date":"2025-08-28T21:43:58Z","type":"stable","version":"0.286"},{"url":"https://github.com/prestodb/presto/releases/tag/0.285","date":"2025-08-28T21:43:54Z","type":"stable","version":"0.285"},{"url":"https://github.com/prestodb/presto/releases/tag/0.284","date":"2025-08-28T21:43:50Z","type":"stable","version":"0.284"},{"url":"https://github.com/prestodb/presto/releases/tag/0.283","date":"2025-08-28T21:43:46Z","type":"stable","version":"0.283"}]` |
| reliability.status_page | yes | - |
| security.disclosure_policy | yes | - |
| security.fedramp | yes | - |
| security.gdpr | yes | - |
| security.hipaa | yes | - |
| security.pci | yes | - |
| security.scorecard | - | 5 |
| security.vulnerabilities | - | `{"count":2,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=maven&package_name=com.facebook.presto%3Apresto-jdbc&per_page=100","last_12m":0,"max_severity":"HIGH"}` |

## Capabilities (Data Warehouse Software)

| Capability | Amazon Redshift | Presto |
|---|:--:|:--:|
| **Deployment** |  |  |
| Deployment | Managed cloud | Self-hosted |
| **Architecture** |  |  |
| Architecture | Separated storage/compute | Separated storage/compute |
| Compute model | Clusters | - |
| **Query** |  |  |
| SQL dialect | Vendor-specific | ANSI SQL |
| Federation / lakehouse query-in-place | ✓ | ✓ |
| **Interoperability** |  |  |
| Table-format support | Iceberg, Parquet | - |
| **Scale** |  |  |
| Concurrency scaling | Automatic | - |
| **Ingestion** |  |  |
| Streaming ingest | ✓ | - |
| **Data model** |  |  |
| Semi-structured (JSON/VARIANT) | Functional | Functional |
| **Analytics** |  |  |
| ML / in-DB functions | ✓ | - |
| **Sharing** |  |  |
| Data sharing / marketplace | ✓ | - |
| **Licensing** |  |  |
| Licence class | Proprietary | Permissive OSS |

*Source: Vioscale. Generated 2026-09-01T14:57:06.828Z. "-" = undocumented, not absent.*