Data Tables

Overview

Data Tables are a mechanism for you to store and organize large volumes of data for reference from plugins. These can be referenced from any plugin and can be versioned based on effective dates using the Versioned Resource Selection feature.

Configuration

The structure of each table is established in configuration by declaring the name of the table along with the number and type of each column. A typical declaration looks like this:

{
  // At the top level of the configuration
  "tables": {
    "personalAutoRates": {
      "selectionTimeBasis": "termStartTime",
      "columns": [
          {
            "name": "state",
            "dataType": "string"
          },
          {
            "name": "baseRate",
            "dataType": "decimal"
          },
          {
            "name": "taxRate",
            "dataType": "decimal"
          },
          {
            "name": "rateCode",
            "dataType": "string"
          }
      ]
    }
  }
}

This declaration declares a table with the static name personalAutoRates, with three columns: a key column called state and three value columns called baseRate, taxRate, and rateCode.

Limitations

Tables support up to one million rows each.