Import Catalog Objects

Objectives

After completing this lesson, you will be able to:

  • Import Catalog Objects

Catalog Objects Import

Lesson Overview

In this lesson, you'll learn how to import catalog objects using the cloud version of the SAP HANA database explorer.

Business Case

As a database administrator, you sometimes need to import tables and data into the SAP HANA Cloud database. The content import function is provided in the SAP HANA database explorer.

The SAP HANA database explorer supports you in importing and exporting catalog objects, including schemas, into your database. The source files must be compressed in .tar.gz format.

Import Catalog Objects

To import database objects from one SAP HANA tenant database to an SAP HANA Cloud database, the following prerequisites must be fulfilled:

  • Database objects being imported must have been previously exported by using the export feature of the database explorer.
  • In the destination database, you must have the INSERT/UPDATE, DROP, or CREATE object privileges for the destination catalog objects.
  • You must have the IMPORT system privilege

Supported import formats:

  • CSV (Comma-Separated Values) file format.
  • PARQUET file format.
Note

It isn't possible to import binary or CSV objects that have been exported from the on-premise SAP HANA Platform, because the two formats and certain data types aren't compatible.

The SAP HANA database explorer for SAP HANA Cloud supports the following import sources:

  • Local Computer
  • Amazon S3
  • Azure Storage
  • Alibaba Cloud OSS
  • Google Cloud Storage
  • Data Lake Files

See the following video to import catalog objects.

Import Catalog Objects

Log in to track your progress & complete quizzes