4.1 Overview

4.1.1 External Tables

4.1.2 Lakehouse Engine

4.1.3 Data Storage

The Lakehouse feature of MySQL HeatWave enables query processing on data resident in Object Storage. The source data is read from Object Storage, transformed to the memory optimized HeatWave format, stored in the HeatWave persistence storage layer in Object Storage, and then loaded to HeatWave cluster memory.

• Provides in-memory query processing on data resident in Object Storage.

• Data is not loaded into the MySQL InnoDB storage layer.

• Supports structured and relational data in the following file formats:

  • Avro.

  • CSV.

  • Parquet.

• With this feature, users can now analyse data in both InnoDB and an object store using familiar SQL syntax in the same query.

To use Lakehouse with HeatWave AutoML, see: Section 3.12, “HeatWave AutoML and Lakehouse”.