7.2.3 Loading AirportDB into HeatWave

To load the airportdb from the MySQL DB System into HeatWave:

Note

If you are using MySQL HeatWave on AWS, you can also load data from the MySQL HeatWave Console. See Manage HeatWave Data with Workspaces, in the MySQL HeatWave on AWS Service Guide.

1. Start MySQL Shell and connect to the MySQL DB System Endpoint.

   $> mysqlsh Username@DBSystem_IP_Address_or_Host_Name

2. Change the MySQL Shell execution mode to SQL and run the following Auto Parallel Load command to load the airportdb tables into HeatWave.

   MySQL>JS> \sql
   MySQL>SQL> CALL sys.heatwave_load(JSON_ARRAY('airportdb'), NULL);

   For information about the Auto Parallel Load utility, see Section 2.2.3, “Loading Data Using Auto Parallel Load”.