9 Manage Data in 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 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 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: 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 HeatWave persistence storage layer, and then loaded to the HeatWave cluster memory. HeatWave Lakehouse supports structured and relational data in CSV, Parquet, Avro, and JSON formats.
• Refreshing Lakehouse Data: Your HeatWave Lakehouse data can be refreshed by a Lakehouse Incremental Load.

• Loading or Unloading Data into HeatWave Cluster
  
• Creating Lakehouse Mapping
  
• Refreshing Lakehouse Data
  
• Maximum Number of Tables Loadable into a HeatWave Cluster