Self-service semantic layer
An abstraction layer enables IT to apply security and business meaning, while enabling analysts and data scientists to explore data and derive new virtual datasets.
A semantic layer generated by your users
Dremio’s semantic layer is an integrated, searchable catalog that indexes all of your metadata, so business users can easily make sense of your data. Virtual datasets and spaces make up the semantic layer, and are all indexed and searchable.
Data curation, without copies
By managing data curation in a virtual context, Dremio makes it fast, easy, and cost effective to filter, transform, join, and aggregate data from one or more sources. And virtual datasets are defined with standard SQL, so you can take advantage of your existing skills and tools.
Use your existing BI and data science tools
Dremio appears just like a relational database, and exposes ODBC, JDBC, REST and Arrow Flight interfaces. So you can connect any BI or data science tool – Tableau, Power BI, Looker and Jupyter Notebooks to name a few.
Fine-grained access control
Dremio provides row and column-level permissions, and lets you mask sensitive data. Role-based access control makes sure that everyone has access to exactly what they need, and SSO enables a seamless authentication experience.
The relationships between your data sources, virtual datasets, and all your queries are maintained in Dremio’s data graph, telling you exactly where each dataset came from.