Skip to main content
Interania

Lookup table

Lookup table columns join a stored column with an optional table of additional attributes.

Use Lookup tables to store information that you’re not collecting with your event data but that you want to associate with the shard key. If the recorded event data lacks dimensions available in other operational data stores such as customer or transaction databases, lookup tables help bring in additional columns. 

There are two types of tables you can create in Interana: an event table and a Lookup table. Generally, Interana recommends storing all of your event data in a single event table (which is different than a relational database model). However, we support Lookup tables, where your primary event table can refer to a separate Lookup table to do static lookups of names and details based on a field in the primary event table.

Lookup tables are analogous to Left Joins in SQL. Because you’re associating static data in the Lookup table with active data (the event data you’re collecting) in your event table, Lookup tables are useful for data that does not change frequently. For example, date of birth, product ID, or ISBN. 

Related terms

  • Was this article helpful?