To load a table into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement.

mysql> ALTER TABLE tbl_name SECONDARY_LOAD;

The SECONDARY_LOAD clause has these properties:

With the guided load feature in MySQL version 8.2.0 or higher, the SECONDARY_LOAD clause also defines the SECONDARY_ENGINE of the table to RAPID and marks all columns with unsupported data types with the NOT SECONDARY attribute.

mysql> ALTER TABLE airport_geo SECONDARY_LOAD;

Warning (code 3877): Command executed during preprocessing: 'ALTER TABLE `airportdb`.`airport_geo` MODIFY `geolocation` point NOT NULL COMMENT '' NOT SECONDARY'.
Warning (code 3877): Command executed during preprocessing: 'ALTER TABLE `airportdb`.`airport_geo` SECONDARY_ENGINE=RAPID'.
Warning (code 3877): 1 InnoDB parallel read thread was requested to load airportdb.airport_geo (session variable value: 4).