MySQL HeatWave User Guide
You can manually load data from InnoDB tables in your DB System
into MySQL HeatWave Cluster by using SQL data definition language (DDL)
such as CREATE
TABLE and
ALTER
TABLE statements.
Perform the following steps sequentially for each table that you want to load:
Exclude table columns with unsupported data types or columns not used in queries
Define a secondary engine on the table.
Load the data from the table or table partitions.
Loading partitions is available as of MySQL 9.1.0.
MySQL version 8.2.0 or higher has a guided load feature which
allows you to skip the first two steps and load the data from a
table or one or partitions of a table directly with a single
ALTER
TABLE statement.