MySQL 8.0.33 introduces Auto Unload, which facilitates the process of unloading data from HeatWave by automating many of the steps involved, including:
Excluding schemas and tables that cannot be unloaded.
Removes the secondary engine flag for tables that are to be unloaded.
Unloading data from HeatWave.
Auto Unload, which can be run from any MySQL client or
connector, is implemented as a stored procedure named
heatwave_unload, which resides in the MySQL
sys schema. Running Auto Unload
involves issuing a
statement for the stored procedure, which takes
options as arguments; for example,
this statement unloads the
mysql> CALL sys.heatwave_unload(JSON_ARRAY("tpch"),NULL);