Amazon Redshift vs Yellowbrick Data Warehouse
Amazon Redshift
aws.amazon.comYellowbrick Data Warehouse
yellowbrick.comSide by side
| Figure | Amazon Redshift | Yellowbrick Data Warehouse |
|---|---|---|
| Price from | $0.54/mo | $0.28/mo |
| Free plan | — | — |
| Free trial | Yes | Yes |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 4 | 3 |
| Spec score · Data Warehouse Software | 8.2 (#6) | 7.8 (#11) |
| Spec score · OLAP Software | 8.3 (#8) | 7.8 (#21) |
| Spec score · Columnar Databases | 8.3 (#7) | 7.8 (#19) |
| Spec score · OLAP Databases | 8.2 (#8) | 7.8 (#18) |
| Spec score · Analytical Data Store Software | 8.2 (#8) | 7.8 (#17) |
| Spec score · Analytics Databases | 8.3 (#9) | 7.8 (#19) |
| Spec score · Analytics Data | 8.3 (#9) | 7.8 (#21) |
| Deployment | It offers provisioned and serverless deployment options. | Yellowbrick is available in AWS, Azure, and Google Cloud environments and on premises. |
| Security | Redshift supports encryption in transit and at rest, row- and column-level access controls, and dynamic data masking. | Security features include OAuth2, Kerberos, LDAP authentication, role-based access control, customer-managed encryption keys, FIPS compliance, and TLS encryption. |
Plans
Amazon Redshift
- Provisioned$0.54 a month
- Serverless$1.50 a month
- Provisioned on-demand$0.54 a month
- Redshift Serverless on-demand$1.50 a month
Yellowbrick Data Warehouse
- On-Demand Monthly$0.28 a month
- Three Year Subscription$482 a year
- One Year Subscription$613 a year
In their own words
Amazon Redshift
Amazon Redshift is a cloud data warehouse for SQL analytics across data warehouses and data lakes. It offers provisioned and serverless deployments, with options AWS says can scale to petabytes and support thousands of concurrent users. Redshift runs read-only SQL queries on Apache Iceberg, Apache Hudi, and Delta Lake tables, plus open file formats in Amazon S3. Zero-ETL integrations connect with Amazon Aurora, Amazon RDS, Amazon DynamoDB, and enterprise applications. Streaming ingestion connects with Amazon Kinesis Data Streams and Amazon Managed Streaming for Apache Kafka. Listed integrations include QuickSight, Tableau, Microsoft Power BI, Alteryx, Jupyter Notebook, Informatica, dbt, MicroStrategy, and Looker. The Data API supports AWS SDK languages including Python, Go, Java, Node.js, PHP, Ruby, and C++. Security includes encryption, row- and column-level controls, and dynamic masking. It is paid, has no free plan, offers a free trial, and starts at $0.54 per month for Provisioned or $1.50 per month for Serverless.
Yellowbrick Data Warehouse
Yellowbrick Data Warehouse is a SQL data platform for data warehousing and application analytics. It handles batch, real-time, ad hoc, and mixed workloads, and can run in AWS, Azure, Google Cloud, or on premises. Storage and compute are separate: virtual compute clusters can be created, resized, and removed on demand through SQL. Yellowbrick Manager is a web interface for instance management, integrations, workload optimization, queries, and query-plan profiling. Third-party tools connect through PostgreSQL-compatible ODBC and JDBC; the documented ecosystem includes Airbyte, Airflow, Kafka, Spark/Databricks, Tableau, and others. Security options include OAuth2, Kerberos, LDAP authentication, role-based access control, customer-managed encryption keys, FIPS compliance, and TLS. Software, data, metadata, logs, and diagnostics can remain in a customer's cloud account, and the product can also run on premises. Global 24×7 support is included without additional support charges. On-demand pricing is $0.28 a month, with cloud or on-premises infrastructure costs separate. A 30-day trial is available through the AWS quickstart page. Subscriptions cover use up to the selected vCPU maximum; unused vCPU hours do not roll forward.