Dremio Integrates Generative AI, Enables Users to Convert Natural Language to SQL Commands Directly

SANTA CLARA, Calif., June 15, 2023 — Dremio today announced the integration of cutting-edge generative AI capabilities into its platform. Text-to-SQL is now available; an Autonomous Semantic Layer and Vector Lakehouse Capabilities are coming soon. These enhancements further solidify Dremio’s commitment to empowering organizations with innovative tools for data exploration, analysis, and discovery. Dremio is ensuring easy self-service analytics—with data warehouse functionality and data lake flexibility—across customer cloud and on-premises data.

Mark Sear, director of data at Maersk, expressed his enthusiasm for these innovative additions to Dremio, stating, “Maersk’s data team is embracing the transformative power of generative AI to enhance our capabilities. By leveraging this cutting-edge technology, Maersk empowers its talented professionals to navigate the complexities of data analysis with unparalleled ease and precision.”

The new generative AI capabilities include:

• Text-to-SQL Experience: Dremio introduces an intuitive and seamless Text-to-SQL experience, allowing users to effortlessly convert natural language queries into SQL directly within the user interface. The Text-to-SQL translation is based on a semantic understanding of metadata and data, resulting in the industry’s most accurate SQL generation. In addition to Text-to-SQL, which is available today, automatic correction of SQL queries is coming soon to further increase SQL development velocity.
• Autonomous Semantic Layer (Coming Soon): Dremio’s upcoming Autonomous Semantic Layer is poised to revolutionize data discovery and documentation. By leveraging generative AI, Dremio automatically learns the intricate details of users’ data, and then produces descriptions of datasets, columns and relationships, eliminating the need for manual cataloging. Additionally, the platform autonomously learns workloads and creates reflections to accelerate data processing, providing users with an AI-powered semantic layer for unparalleled data insights.
• Vector Lakehouse Capabilities (Coming Soon): Dremio continues to push the boundaries of data analytics with its upcoming Vector Lakehouse Capabilities. By seamlessly integrating these capabilities into the lakehouse, Dremio will enable users to store and search vector embeddings. This provides the foundation for users to build machine learning applications such as semantic search, recommendation systems, and anomaly detection—all within the Dremio platform.

Dremio’s commitment to leveraging generative AI to enhance its platform showcases the company’s dedication to empowering users with advanced data exploration and analysis tools. The Text-to-SQL Experience, Autonomous Semantic Layer and Vector Lakehouse Capabilities collectively solidify Dremio’s position as an industry leader in data analytics innovation.

“Dremio empowers the world’s leading organizations with advanced data capabilities, and today we take another significant leap forward. By integrating generative AI capabilities into our platform, we are accelerating data workflows and eliminating much of the manual work involved in SQL development, data catalog creation and curation, and more. In addition, by delivering vector database capabilities directly in the lakehouse, we will enable companies to build AI-powered applications without creating additional data silos in the organization. Generative AI will transform data engineering, data science and analytics over the coming years, and we are excited to provide our users with the industry’s most powerful tools to uncover the true potential of their data,” said Tomer Shiran, founder and CPO of Dremio.

About Dremio

Dremio is the easy and open data lakehouse, providing self-service analytics with data warehouse functionality and data lake flexibility across all of your data. Use Dremio’s lightning-fast SQL query service and any other processing engine on the same data. Dremio increases agility with a revolutionary data-as-code approach that enables Git-like data experimentation, version control, and governance. In addition, Dremio eliminates data silos by enabling queries across data lakes, databases, and data warehouses, and by simplifying ingestion into the lakehouse. Dremio’s fully managed service helps organizations get started with analytics in minutes, and automatically optimizes data for every workload. As the original creator of Apache Arrow and committed to Arrow and Iceberg’s community-driven standards, Dremio is on a mission to reinvent SQL for data lakes and meet customers where they are on their lakehouse journey.

Source: Dremio