MySQL HeatWave User Guide
In the event of a problem where query processing stops or the MySQL HeatWave Cluster stops, the external tables are recovered when the Cluster resumes and begins processing queries again using the MySQL HeatWave recovery process. See the following to learn more:
MySQL HeatWave Cluster Failure and Recovery in the MySQL HeatWave on OCI Service Guide.
MySQL HeatWave Cluster Data Recovery in the MySQL HeatWave on AWS Service Guide.
Restore a Database in the MySQL HeatWave for Azure Service Guide.