Dremio Sonar

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.

Access more data freely
and make better business decisions

One engine for all SQL workloads

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.

Learn more about the Sonar query engine >

Consistent, collaborative data

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.

Learn more about Spaces >

Best-in-class experience

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.

Frictionless BI integrations

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.

Learn more about BI integrations >

Simplified Architecture

A better experience
for all data practitioners

FOR DATA TEAMS

  • 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.

  • Centralized metrics layer

    Define standardized business metrics that can be leveraged by any downstream application.

  • Built-in governance and lineage

    Add context and tags to datasets for teammates to leverage, and trace what datasets comprise each analysis through a built-in lineage graph. Enable users to explore and develop datasets without making data copies, identify your most frequently-queried datasets, and surface only your most valuable data assets for public consumption.

FOR DATA CONSUMERS

  • Self-service experience

    Consume and collaborate with data on your own terms. Leverage your organization’s production-ready datasets for your analyses, and safely experiment without creating and managing data copies.

  • Better insights with fresher data

    Don’t build reports on stale data. Deliver reliable, consistent insights based on fresher, more complete data as it lives in the data lake.

  • Transparent performance

    No more worrying about BI extracts or physically optimized tables. Work directly with your logical data model, and Sonar transparently optimizes and accelerates queries to ensure sub-second responsiveness for all workloads.

Deliver insights.
Securely.

End-to-end data security

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.

Centralized governance

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.

Get Started Free

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

Sign Up Now

Watch Demo

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

Check Out Demo