Skip to main content
Some data has no upstream source: a list of target accounts, a mapping your team maintains, a set of thresholds. A data table keeps that data in Summation, where Addison and your artifacts can read it alongside everything else. A data table is a hand-authored Summation table, a grid you fill in and maintain yourself. Reach for one when you want reference or master data, a manually curated list, or any dataset you’d rather enter by hand than import or compute.

​
What you can do

  • Edit rows directly in the grid: add, update, and delete.
  • Add columns of any type (Text, Integer, Number, Date, Boolean), plus SQL / computed columns and Dimension columns that reference a dimension table.
  • Mark one column as the table’s key with the Set as key radio in the grid. The primary_key is shown read-only, and “business keys” is only a backend parameter on the upsert path, so neither is set here.

​
Create a data table

On the Tables page, click Create → Data Table. You land on the table’s grid, where the + Add column menu adds typed or computed columns and you enter rows.
A data table 'DemoDataTable' with a '# Height' column and a '+ Add' column button; the Add-column menu lists SQL, Dimension, Boolean, Date, Integer, Number, and Text.

Adding a column to a data table