(Glue-2311) Create SNP Glue™ Table from External Table

Owned by SNP
Nov 24, 2023

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:

  1. Go to SNP Glue™ Data Dictionary or Object Navigator.
  2. 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.
  3. Specify the following popup fields: 
  • SNP Glue™ Table: Name for the newly created SNP Glue™ table.
  • Description: Description of new SNP Glue™ table.
  • External table: Name of the existing External table from which the 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: Package where the 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).

Note that data elements must be defined manually if needed.


Practical use-cases:

Storage to Storage extractor - you can extract data between two 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 the original SAP data.