9 Manage Data in MySQL HeatWave
The Workspace tab in the MySQL HeatWave Console contains a Data Management tab, which enables you to perform the following:
- Loading data into or unloading data from a MySQL HeatWave Cluster: Load operations are performed using Auto Parallel Load, which optimizes operation time and memory usage by predicting and using an optimal degree of parallelism. Data is loaded into MySQL HeatWave from the associated DB System. If you have not loaded data into the DB System, see Importing Data. Unload operations are performed using Auto Unload.
- Creating Lakehouse Data Mapping: MySQL HeatWave Lakehouse enables query processing on the data residing in an Amazon S3 bucket. The source data is read from an Amazon S3 bucket, transformed into a memory-optimized format, stored in the MySQL HeatWave persistence storage layer, and then loaded to the memory. MySQL HeatWave Lakehouse supports structured and relational data in CSV, Parquet, Avro, and JSON formats.
- Refreshing Lakehouse Data: Your MySQL HeatWave Lakehouse data can be refreshed by a Lakehouse Incremental Load.