• Home
/
• Working in m3ter - User Guides

Lookup Tables (Beta)

Lookup Tables enable you to manage dynamic data mappings that your calculations reference. Use them for currency conversion, pricing tiers, discount rates, and similar scenarios where you require values to change operationally but for calculation logic to remain constant.

Lookup Tables are designed for very high throughput and millisecond latency, and can be used at any rate supported by the services that query them - for example, multiple lookups can be made for each measurement being ingested and enriched, thousands of times a second.

How to Use Lookup Tables

Lookup Tables employ a table and revision model, which lets you update data cleanly, and extend the schema without modifying existing calculations. Here are the steps for working with this model:

1. Create one or more Lookup Tables in your Organization.

2. Create Revisions for a Lookup Table, which you can use to define data schema and lookup keys.

3. Populate Draft Revisions with data values. You can create and edit multiple Draft Revisions, but only one can be Published at any given time.

4. Publish a Revision to activate it. Once published, you can use Lookup Functions within your Derived Field calculations to query the data values of the Revision.

5. When you want different, updated data values to be used, publish the draft Revision containing the required new values. The currently published Revision is archived automatically, so you can always access the historical data.

This section uses a variable usage discounting rate example to explain how to create and manage Lookup Tables and their Revisions, add data to Revisions, publish Revisions, and use Lookup Tables in Derived Field calculations to fulfill this kind of dynamic data mapping use case:

• Creating and Managing Lookup Tables

• Adding Data to, Publishing, and Managing Lookup Table Revisions

• Worked Example - Variable Usage Discounting

• Lookup Functions - Querying data from Lookup Tables

Additional Support