(Glue-2302) Create SNP Glue™ table from external table

Using this functionality, you can create the SNP Glue™ table from a table or a structure that exists on external storage (e.g. Hive on Hadoop, Redshift table, or HANA Native structure).

SNP Glue™ table will be in this case only a pointer to the external table.

After the SNP Glue™ table is created, you can use it for all available features: Data Browser, Data extractions, and InfoProviders.

Procedure

Go to SNP Glue™ Data Dictionary or Object Navigator
Press Create SNP Glue™ table from an external table icon in SNP Glue™ Data Dictionary or select the package in the context menu or SNP Glue™ Tables in Object Navigator
Specify the following popup fields:

SNP Glue™ Table – the name for the newly created SNP Glue™ Table
Description – description of new SNP Glue™ Table
External table – the name of the existing External table from which SNP Glue™ Table will be created
Object is view – is the external object a view?
Storage ID – defines storage where the external table exists
Package – the package where new SNP Glue™ Table will be created

4. Proceed

5. New SNP Glue™ table is created.

Data types of created SNP Glue™ table are automatically converted from external storage types to standard SAP types (e.g. in case, the SNP Glue™ table is created based on a HIVE table, the field types are automatically converted from HIVE types).

Please note that data elements must be defined manually if needed.

Practical use-cases:

Storage to Storage extractor - you can extract data between 2 external storages. You only need to create SNP Glue™ tables from external storages and create an extractor for data transfer.

In the case of data extraction to .csv files, usually, the customer has custom processing of the data. If such processing generates tables from the provided data, using the external SNP Glue™ table (pointing to the generated table) you can validate the processed data with original SAP data.