Documentation Home
MySQL HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.6Mb
PDF (A4) - 1.6Mb

MySQL HeatWave User Guide  /  ...  /  Unloading Data Using Auto Unload

2.5.2 Unloading Data Using Auto Unload

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 CALL statement for the stored procedure, which takes schemas and options as arguments; for example, this statement unloads the tpch schema:

mysql> CALL sys.heatwave_unload(JSON_ARRAY("tpch"),NULL);