Dremio Unveils Next-Generation Reflections: A Leap Forward in Accelerating SQL Query Performance on the Data Lakehouse  

September 13, 2023

Easy and Open Data Lakehouse Technology Empowers Organizations with Sub-Second Analytics Across All Data

SANTA CLARA, Calif. – September 13, 2023Dremio, the easy and open data lakehouse, today announced the launch of its next-generation Reflections technology, revolutionizing the landscape of SQL query acceleration. Dremio Reflections pave the way for sub-second analytics performance across an organization's entire data ecosystem, regardless of where the data resides. This transformative technology redefines data access and analysis, ensuring that insights can be derived swiftly and efficiently and at 1/3 the cost of a cloud data warehouse.

Reflections are Dremio’s innovative SQL query acceleration technology. Queries using Reflections often run 10 to 100 times faster than unaccelerated queries. The new launch introduces Dremio Reflection Recommender, a ground-breaking capability that lets you accelerate Business Intelligence workloads in seconds. Reflection Recommender automatically evaluates an organization's SQL queries and generates a recommended Reflection to accelerate them. Reflection Recommender eliminates arduous manual data and workload analysis, ensuring the fastest, most intelligent queries are effortless and only a few keystrokes away. Reflection Recommender is easy to use and puts advanced query acceleration technology into the hands of all users, saving significant time and cost.

Andy Kenna, senior vice president and head of data at RenaissanceRe, attests to the impact of Dremio Reflections, saying, "Dremio slashed our query times by over 99%, massively reducing our analytics costs. We had a production query that took 70 minutes to return. We deployed Dremio on top of Amazon S3, and query time dropped to 33 seconds. With Dremio Reflections, the query time was accelerated even further to just three seconds. We’re all blown away by the shocking performance we get from Dremio and Reflections."

Dremio has also optimized how Reflections are refreshed to further enhance query performance and drive cost efficiencies. Dremio now intelligently refreshes Reflections on Apache Iceberg tables to instantly capture incremental data changes. This powerful approach eliminates the need for full data refreshes, resulting in faster updates and lower compute costs.

Dremio Reflections eliminate performance challenges for BI dashboards and reports, and eliminate the need for data teams to export data from the lakehouse into BI extracts or imports for analytics. With Reflections, there’s no need to create precomputed tables in the data lake or data warehouse to achieve the sub-second performance for BI workloads, reducing work and complexity for data teams.

"Dremio Reflections accelerate SQL queries by orders of magnitude, eliminating the need for BI extracts/imports and enabling companies to run their most mission-critical BI workloads directly on a lakehouse," said Tomer Shiran, founder of Dremio. "With automatic recommendations and next-generation incremental updates, we’ve made it even easier for organizations to take advantage of this innovative technology."

To see Reflections in action, visit www.dremio.com to download Dremio Cloud for free. Or, read this Reflections Tutorial blog to learn more.

About Dremio

Dremio is the easy and open data lakehouse, providing self-service analytics with data warehouse functionality and data lake flexibility across all of your data. Use Dremio's lightning-fast SQL query service and any other processing engine on the same data. Dremio increases agility with a revolutionary data-as-code approach that enables Git-like data experimentation, version control, and governance. In addition, Dremio eliminates data silos by enabling queries across data lakes, databases, and data warehouses, and by simplifying ingestion into the lakehouse. Dremio's fully managed service helps organizations get started with analytics in minutes, and automatically optimizes data for every workload. As the original creator of Apache Arrow and committed to Arrow and Iceberg’s community-driven standards, Dremio is on a mission to reinvent SQL for data lakes and meet customers where they are on their lakehouse journey.

Hundreds of global enterprises like JPMorgan Chase, Microsoft, Regeneron, and Allianz Global Investors use Dremio to deliver self-service analytics on the data lakehouse. Founded in 2015, Dremio is headquartered in Santa Clara. CNBC recognized Dremio as a Top Startup for the Enterprise and Deloitte named Dremio to its 2022 Technology Fast 500. To learn more, follow the company on GitHub, LinkedIn, Twitter, and Facebook, or visit www.dremio.com.

Media Contact

Elise Woodard

[email protected] 

get started

Get Started Free

No time limit - totally free - just the way you like it.

Sign Up Now
demo on demand

See Dremio in Action

Not ready to get started today? See the platform in action.

Watch Demo
talk expert

Talk to an Expert

Not sure where to start? Get your questions answered fast.

Contact Us

Ready to Get Started?

Bring your users closer to the data with organization-wide self-service analytics and lakehouse flexibility, scalability, and performance at a fraction of the cost. Run Dremio anywhere with self-managed software or Dremio Cloud.