9 Manage Data in HeatWave with Workspaces

The Workspaces page in the MySQL HeatWave Console 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 and Parquet formats.

  HeatWave Lakehouse is supported on the HeatWave.256GB shape only. Lakehouse supports a maximum of 512 HeatWave nodes.

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