6.2.1.1 Importing Sample Database

Oracle provides on AWS sample databases for you to test out HeatWave on AWS. Use the Import sample data feature in HeatWave Console to import the sample database into a DB System in any region by just a few clicks.

Currently, the following sample databases are available from Oracle.

• airportdb. See Running AirportDB Queries and Additional AirportDB Queries.
• TPCH. You have to select a size for your TPCH sample database—you are suggested to choose a value that matches the expected workload on your DB system. Please also pay attention to the Disclaimer. See Running tpch Queries and Sample TPCH queries.

This task requires the following:

• Access to HeatWave Console.
• An established connection from the HeatWave Console to the DB System into which you want to import data.

Follow these steps to import the sample database:

1. In the HeatWave Console, click the Workspaces tab, and then click the Data Imports tab.
2. Click Import Data.
3. In the Import data into DB System pane, under Source, select Import sample data. A list of sample databases appear, together with information for each of them like the name of the destination schema and the size.
4. Select a sample database. You might have to make additional selections, depending on the sample database you choose.
5. Click the Import button. The data import operation begins.

The Data Imports tab is shown, on which you can view details on your import operation.

Parent topic: Data Import Feature