
- Runtime filtering improvements
- Reflections cache performance enhancements
- Query planning and performance improvements
- Arrow Flight server endpoint preview
- AWS Edition support for smaller EC2 instance types
Runtime Filtering
To improve performance in traditional data warehouse schemas, last month’s Dremio 4.8 release introduced support for runtime filtering. Runtime filtering enables Dremio to dynamically apply filters from a smaller joined table to a larger table in order to enhance filtering on larger tables and significantly increase performance. When this feature was released, it only supported partitioned columns. Today we are excited to announce that Dremio 4.9 expands the types of workloads that runtime filtering supports by adding support for non-partitioned columns as well. This capability can result in orders of magnitude performance improvements when working with traditional star schemas. The feature is automatically enabled and requires no tuning or administration. Instead, Dremio simply applies filters from a joined table as they are generated.Reflections Cache Performance Improvements
In this release, Dremio enhances the caching of reflections. Through the use of Apache Arrow reflections, Dremio 4.9 reduces query processing time up to 80% compared to the performance of queries that use reflections stored in Apache Parquet files.Columns Involved in Query. | Processing Time (Parquet reflections) in seconds. | Processing Time (Arrow reflections) in seconds. | Percentage Improvement. |
2 (all int) | 0.150 | 0.073 | 51% |
4 (all int) | 0.290 | 0.136 | 53% |
8 (4 int, 4 varchar) | 1.620 | 0.265 | 84% |
12 (8 int, 4 varchar) | 1.839 | 0.371 | 80% |
Query Planning and Performance Improvements
In addition to accelerating query performance, Dremio 4.9 continues to make time to insight even faster by reducing query planning times by up to 30x for queries with a large number of reflections or complex multilevel joins.Arrow Flight Server Endpoint
Dremio AWS Edition Enhancements
Dremio 4.9 also adds enhancements to Dremio AWS Edition. For example, starting in this release, users have the option to launch a Dremio AWS Edition environment with smaller engine instance types, providing users a lower cost option for experimentation and evaluation purposes.Learn More
For a complete list of new features, enhancements, changes and fixes, please review the release notes. As always, we look forward to your feedback. Please post any questions or comments on our community site.Ready to get started?

Dremio Test Drive
Experience Dremio with sample data
The simplest way to try out Dremio.
Dremio Cloud
Open & fully-managed data lakehouse
Best Option if your data is on AWS. Forever Free Usage.

Dremio Software
Software for any environment
Download Dremio’s Community Edition