Simpler data model
Expose a more logical view of data for end users, and eliminate the need for precomputed, pre-aggregated/joined physical tables that users have to navigate through.
A SQL engine for open platforms that provides data warehouse-level performance and capabilities on the data lake, and a self-service experience that makes data consumable and collaborative.
Support all SQL workloads, from mission-critical BI dashboards to ad-hoc/exploratory workloads, with an engine that delivers warehouse performance and functionality (including DML operations) directly on the lakehouse.
Enrich your analyses with data that’s not [yet] in the lake with connectors to various external databases.
Deliver a seamless end-user experience with transparent query optimization and acceleration.
Define a consistent and secure view of data and business metrics that can be leveraged by any downstream application.
Build a simpler data model, and eliminate the need to export data into Tableau extracts/Power BI imports, cubes, and other optimized data structures.
Curate, analyze, and share datasets in a self-service manner. Work with the most logical view of data, without needing to know about pre-optimized, pre-aggregated physical tables.
Interact with your data through a seamless integrated experience for analysts who know and love SQL.
Query your lakehouse data with Sonar’s SQL Runner, a best-in-class IDE for analysts that includes auto-complete, multi-statement execution, and the ability to save and share SQL scripts.
Understand and optimize query performance with Sonar’s SQL Profiler, and visualize dataset usage and lineage with Sonar’s Data Map.
Easily connect to Sonar and visualize data with your favorite BI tool with native connectors in leading BI tools like Tableau and Power BI, including support for OAuth 2.0-based SSO.
Launch your favorite BI tool in context, directly from the Dremio UI.
Keep your data and data processing in your cloud account, where data is encrypted at rest and in transit. Manage risk with SOC 2 compliance, and integrate with existing platform security tools including Azure Active Directory, Okta, Ranger, Privacera, and Okera.
Define a single, governed view of data, with centralized access policies over your data that can be reused by any downstream applications. Safeguard your data further with fine-grained database-style permissions using ANSI SQL.