Redshift
Alternative
for Fast & High Concurrency
Analytics
Firebolt is a next-generation cloud data warehouse that has added a number of innovations on top of what Redshift and Snowflake have done to improve performance and lower TCO. Firebolt has been deployed side-by-side with Redshift or Snowflake, or as a replacement. It has generally been deployed in weeks. Firebolt has added to deliver up to 102x greater performance, unlimited scalability, and up to 10x lower cost.
Firebolt's innovations include:
Optimized Firebolt File Format (F3) storage
F3 storage minimizes data access over the network and combines the best of columnar storage with support for continuous updates and native semi-structured data storage to deliver high performance access.
Indexing
Indexing on top of F3 to achieve sub-second performance. This includes sparse Indexing with sorting and clustering to help prune which partitions and nodes to include in a query; aggregating indexing for fast group by operations; and join indexing to speed up joins without materialized views.
New Query engine
A new, next generation query engine that is designed for multi-workload performance. Features include vectorized processing, JIT compilation, cost-based optimization, indexing, and a host of tuning options to improve query performance and prioritization
Native semi-structured data support
Allows any combination of flattening and nested storage with native Lambda-style functions in SQL for high performance analytics
Tuning
Tuning has in the past been hidden to make administration easier. This is changing. Now some vendors are allowing choice of instance types (CPU, RAM, SSD), data formats and partitioning, query prioritization, indexes, sorting and clustering
Choice of engine and node types
Choice of engine and node types to optimize performance for ETL or querying, and for different types of workloads. Firebolt allows you to choose any node size, and any number in each engine, to meet your exact needs.
10x greater efficiency
Firebolt saves you up to 10x on resources through greater engine efficiency and choice of the best resources for each engine.
Redshift Comparison
Compare Redshift to other cloud data warehouses in a side-by-side comparison across more than 30 different categories including:
Architecture: elasticity, technology support, isolation and security
Scalability: elastic scale, scale efficiency, query and user concurrency
Performance: query, indexing, data type and storage optimization
Cost: administration, infrastructure resources, vendor pricing
Use cases: reporting, dashboards, ad hoc, operations and customer-facing analytics
%20logo.png){kind=icon}