(GLUE-1806) Create Glue table

Owned by SNP
Jul 04, 2018
3 min read

Attributes

In the initial screen, enter the name of the new table and push Create.

In the main screen – Attributes tab you can see following fields:

  • Short Description – description of the table
  • Use meaningful values – transforms original values into more meaningful ones, use this link to get more information.
  • Data enrichment - includes data from SAP master data into transactional data, you can find more information here.
  • StorageID (Load) – defines a connection to storage (Hadoop cluster).


Storage Management button navigates you to Storage Management setup transaction. There you can see and manage (if your user has privileges to do so) storages. 

Fields

Fields section defines fields (columns) of the new table. 

Each field contains following attributes:

  • field name
  • key field - if marked, this field is a key field (part of primary key of the table)
  • data element 
  • data type
  • data type length
  • number of decimal places
  • short text (description)

You can either manually insert the fields, or import them from existing SAP table.

Insert fields manually

You can manually manipulate the table using buttons from the toolbar

  • Append Row: Appends new row at the end of the table
  • Insert Row: Inserts new row above the highlighted row
  • Delete Row button: Deletes the highlighted row
  • DataType/Element specification button helps you to specify the parameters of the field. You can either manually specify the Data Type, Length and Decimal Places, or choose the DataElement (all previously mentioned parameters will be filled automatically). 

Import fields 

Use Import Fields to generate the field structure of glue table based on existing SAP DDIC table or InfoProvider. The data elements, types, lengths, and descriptions are same as in the source table. 

Use meaningful fields setting helps you to define the fields name. You can use standard SAP field names or "meaningful" ones. See this link for more info.

Save & Activate

You can save the table anytime during your work. If the table was not saved before, the system will prompt for package assignment.


All the actions made so far are made on SAP side and have no effect on Hadoop system.

The table is created on external storage (Hadoop) only after you activate it.