7.2.3 Loading AirportDB into HeatWave MySQL

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

Note

For HeatWave on AWS, load data into HeatWave using the HeatWave Console. See Manage Data in HeatWave with Workspaces in the 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”.