Dremio has announced “innovations” that deliver sub-second query response times on cloud data lakes and support for thousands of concurrent users and queries.
In addition, Dremio now includes built-in integration with Power BI that enables users to launch these business intelligence tools and immediately start querying data via a live connection to Dremio.
The latest Dremio product release enables companies to run production BI workloads. These include interactive dashboards, directly on Amazon S3 and Azure Data Lake Storage — without having to move data into data warehouses, cubes, aggregation tables or extracts.
The new capabilities are claimed to deliver self-service access to data. They enable analysts to see results immediately, eliminating their dependency on manual ETL processes or data engineering.
Dremio can now cache data reflections in the Apache Arrow format so the data can be directly loaded into memory with zero overhead. This eliminates the need to decode and decompress data at runtime, enabling sub-second query response times for BI dashboards.
Dremio also supports multiple coordinator nodes, allowing companies to run high-concurrency workloads consisting of thousands of simultaneous users and queries.
Dremio now automatically leverages runtime intelligence from dimension tables to reduce the amount of data that must be read from a fact table.
Further, the deeper integration between Microsoft Power BI and Dremio enables users to launch Power BI directly from the Dremio interface with the click of a button.
Power BI then automatically connects using a native Dremio connector, so users can easily transition from building a dataset in Dremio to analyzing their data in Power BI.