Reminder: This tutorial is part of a mission, in which you will help Alex, the CEO of Best Run Travel, to answer a concrete business question with SAP HANA Cloud, SAP HANA database.
Alex needs to know the top 5 partners of their agency and wants to find out the days with maximum booking of each partner.
Step 1Download the sample data set
—
SAP provides a free data model focused on flight data for anyone to use. We’re going to import this sample data and use it to help you complete the mission for Best Run Travel.
Download the SFLIGHT sample data from the public SAP GitHub repository and save it on your local machine.
Note the location of the file.
Step 2Import the data to your catalog
+
The Import and Export application in SAP HANA Cloud Central simplifies operations involving getting data into or out of your SAP HANA Cloud instance. The following steps demonstrate how it can be used to import a sample dataset.
In the pane on the left, select the Import and Export application and click on Import.
import and export app
Select the instance that the data will be imported to and click next.
Choose to import catalog objects, specify that the import will be from a local file (as opposed to a file on a cloud storage provider), and browse to the previously downloaded file and click next.
catalog import
The list of available objects to be imported is shown. Select them all and click Add to List. It is possible at this point to optionally rename the schema that these object will be imported. Click next.
object selection
The options for the import are shown next. Click Import to start the import operation.
Once the import is completed, the state will change to completed.
import state
Step 3Preview the data
+
Once the data is imported, you can take a look at the imported tables in the database objects app and execute SQL queries against the tables in the SQL Console.
Open the database objects app, connect to the instance, specify a schema filter of SFLIGHT, and click on tables.
SFLIGHT objects
Select a table such as SAIRPORT, and choose SELECT Statement from the Generate SQL Statement dropdown.
Open Data
The data of the table will now appear in the SQL Console.
SQL Query
You can browse the dataset to get a better overview of the data available.
Well done!
You have completed the fifth tutorial of this mission! Now you know how to import tar.gz files to your database.
Learn in the next tutorial how to create and manage users and privileges.
Share feedback on this tutorial or join the conversation in SAP Community.
Submit detailed feedbackDiscuss in Community
Steps
Step 1 of 4
1. Download the sample data set2. Import the data to your catalog3. Preview the data4. Knowledge Check
Joule
AI Notice
Joule is an AI assistant. Generative AI may produce inaccurate, incomplete, or biased information. Always verify important details before acting on them.
Conversations are sent to SAP-hosted large language models for processing. Do not include personal data, credentials, or confidential information in your messages.
Joule's responses are based on the SAP tutorial catalog and may not reflect the latest product changes. For authoritative guidance, consult the linked tutorials and official SAP documentation.
