2.2.2.2 Defining the Secondary Engine

Both Guided Load and Auto Parallel Load will define the secondary engine as RAPID to load the table into HeatWave.

As of MySQL 9.1.0, after unloading a table, and to prevent Auto Parallel Load from automatically loading the table into HeatWave, set the secondary engine to something other than RAPID:

mysql> ALTER TABLE tbl_name SECONDARY_ENGINE = NOT_AUTO;