Today, we announced the general availability of MySQL HeatWave Lakehouse and new capabilities in MySQL Autopilot that enable organizations to efficiently query data from object store using standard SQL syntax and without requiring database tuning expertise. Data in object store can be in a variety of file formats like CSV, Parquet or export from databases like Aurora, Redshift, and even MySQL. With MySQL HeatWave Lakehouse, users can query up to half a petabyte of data from object storage and optionally combine it with transactional data from MySQL database in a single SQL query. Data in object store remains in object store and is not copied into the MySQL database.MySQL HeatWave Lakehouse is a feature of MySQL HeatWave which is a fully managed database service, powered by a highly parallel in-memory query accelerator.
It delivers the best performance and price-performance in the industry for data warehouse workloads. It offers fully automatic in-database machine learning processing. Furthermore, it is the only cloud database service that combines transactions, analytics, automatic machine learning and now querying object store into one MySQL database, delivering real-time, and secure analytics without the complexity, latency, and cost of ETL duplication.
MySQL Autopilot is an integrated feature of MySQL HeatWave that provides machine-learning based automation for various database operations and eases the burden for the developer and the DBA. It has been enhanced for Lakehouse and is instrumental in making MySQL HeatWave Lakehouse adept at scaling, loading, and processing so efficiently. Here are some MySQL Autopilot features which have been developed for HeatWave Lakehouse: