Skip to main content
When the same join or rollup keeps getting rewritten, a calculation table makes it a first-class dataset: defined once, refreshable, and available to Addison, artifacts, and the catalog like any other table. A calculation table is a Summation table defined by a SQL SELECT over your existing tables. Use it for derived datasets: aggregations, rollups, joins, and summaries computed from other tables.

​
What you can do

  • Define the table with a SQL query; its columns come from the query.
  • Materialize it the first time, then refresh (synchronize) it to recompute from the latest source data.
  • Trace its lineage back to the tables it reads from.

​
Create a calculation table

On the Tables page, click Create → Calculation Table, then write the SELECT in the SQL editor and Run it. Saving does not materialize the result. It applies the SQL as a column change and leaves the table unmaterialized, so materialize it separately (see the API tab) before it can be queried.
A calculation table 'DemoCalcTable' showing a data grid (ID, Name, Sex, Age columns) above a SQL editor with 'Run' and a 'Saved' indicator, running SELECT * FROM olympics_event LIMIT 50.

A calculation table's SQL