Lookup Tables

Overview

In addition to creating virtual properties directly based on properties already buried, we can also associate other tables in the  lookup table  (before SDH component version 1.3.1, the menu name was "Dimension Association") module. Introduce dimension information from other tables to create more complex virtual property applications.

Suppose we have a pay_order event in the event table with attributes such as product_id, product_name, and so on. Now we want to use more other dimensions of the product to analyze (such as product_manufacturer), but these dimensions are not entered into the system at the time of burying, then we can associate the product table to meet this requirement.

In lookup table module views the data table associated with the current table and in Data Fusion > Universal Data Access > Data Table Management module views the attribute information in the association table.

Add lookup table

1. Select Data Fusion > Metadata Management > User Table/Event Table > lookup table.
2. Click the Add lookup table  button in the upper right corner.
3. Select the data table . Support selectData Fusion > Universal Data Access > Data Table Management in module Primary Key Table and withUnique key data table.
4. Fill in Association table alias. When you need to associate the same table multiple times with different association conditions, set this for this table alias. You need to reference an alias to create virtual attributes using fields in the associated table.
5. Set Association Condition. Set the association condition between the current table and the associated table. The data type of the attribute must be the same. Multiple association condition combinations are supported.
   1. Left: Fields in the lookup table to be associated. The primary key or unique key of the table must be used as the association condition and cannot be deleted.
   2. Right: Optional Current Table Attribute or fixed value.
      1. Current table properties: Optional in the current users/events table common attribute , support < The string String> , < Number> , < Long integer BigInt> Type, which stands for Join by field.
      2. Fixed value: You can enter a fixed value to filter conditions in the association table.
6. Click next step, create associated attributes in batches. On this page, all fields in the lookup table are displayed. You can edit and adjust the attribute name and attribute display name. After you click Submit, the system automatically creates selected fields as virtual attributes. (Note: This step is included in SDH component version 1.3.1 and later. Virtual properties need to be created manually after version 1.3.1.)

Manage lookup table

On the lookup table list page, you can search, filter, sort, and delete created relationships.

If a virtual property has been created through the current association, the dimension association cannot be deleted.

Permission

Having view main table, view event table permission, can view the dimension association on the corresponding page.
Having manage main table、manage event table permission, can manage the dimension association between user tables and event tables.