Using this functionality, you can create a Glue table from a table or a structure that exists on external storage (e.g. Hive on Hadoop, Redshift table, or HANA Native structure).
Glue table will be in this case only a pointer to the external table.
After a Glue table is created, you can use it for all available features: Data Browser, Data extractions, and InfoProviders.
Procedure
- Go to Glue Data Dictionary or Object Navigator
- Press Create Glue table from an external table icon in Glue Data Dictionary or select the package in the context menu or Glue Tables in Object Navigator
- Specify the following popup fields:
- Glue Table – the name for the newly created Glue Table
- Description – description of new Glue Table
- External table – the name of the existing External table from which 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 Glue Table will be created
4. Proceed
5. New Glue table is created.
...