Dremio, the easy and open data lakehouse, is offering key new features to enable customers to create their data lakehouses more easily by performantly loading data into Apache Iceberg tables, query and federate across more data sources with Dremio Sonar, automatically format SQL queries in the Dremio SQL Runner, and securely connect Microsoft PowerBI using single sign-on (SSO).
Dremio also has added roll back and data optimization features for Apache Iceberg tables, making it simple to manage data lakehouses using the open table format standard, according to the company. Furthermore, customers can now use several new SQL functions for an even better SQL experience.
Dremio’s expanding functionality with Apache Iceberg now includes:
- Copying data into Apache Iceberg tables
- Optimizing Apache Iceberg tables
- Table roll back for Apache Iceberg
Dremio’s new functionality also includes new connectors for Microsoft PowerBI, Snowflake, and IBM Db2. Customers using Dremio and PowerBI can now use single sign-on (SSO) to access their Dremio Cloud and Dremio Software engines from PowerBI, simplifying access control and user management across their data architecture.
The Snowflake and IBM Db2 connectors give customers the ability to quickly add Snowflake data warehouses and IBM Db2 databases as data sources for Dremio. This makes it easy to include data in these systems as part of the Dremio semantic layer, enabling customers to explore this data in their Dremio queries and views, according to the vendor.
Additionally, customers can now add Dremio clusters as data sources, enabling query federation across these clusters.
This feature set enables connectivity across Dremio environments, including hybrid environments where you have Dremio clusters running in a public cloud and on-premises.
This makes it easy to extend Dremio semantic layers across clusters, giving analysts and BI engineers access to more datasets and insights. Along with popular connectors already operational like Tableau, ThoughtSpot, dbt, and Alteryx, these new connectors add more flexibility for customers, according to the vendor.
“It’s been great to see the incredible growth of our product driving value for our customers,” said Tomer Shiran, co-founder and CPO of Dremio. “Every company we speak to is struggling to help their businesses move faster and self-serve while maintaining security and governance. Data Meshes solve for these competing priorities, and we’ve been innovating to make it easier and easier for companies to create and operate data mesh architectures.”
For more information about this news, visit www.dremio.com.