> ## Documentation Index
> Fetch the complete documentation index at: https://docs.summation.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Tables

> The data behind everything in Summation — Summation tables you build, import, or compute, plus connector-backed tables.

**Tables** are the data behind everything in Summation — the rows your [reports](/features/artifacts/reports), [dashboards](/features/artifacts/dashboards), and [Addison](/features/addison) read from. They live in your organization's data grid at `/table` and come in two types: **Summation tables** (you create, import, or compute them in Summation) and **connector tables** (backed by an external source through a [connector](/features/connectors)).

<Frame caption="The Tables page">
  <img src="https://mintcdn.com/summation-676748f5/ewrpxeNnW54PEh54/images/features/tables/tables-home.png?fit=max&auto=format&n=ewrpxeNnW54PEh54&q=85&s=a0cd55508bfbf8f489e59f135955cb15" alt="The Tables page titled 'Create and manage your tables', with a Create button top-right. Type filter chips read All, Summation (86), BigQuery (8), Snowflake (1), and GitHub (0). A table lists folders and tables with Name, Type, Column, Source, and Last refreshed columns; a Data files tree sits on the left." width="2948" height="1958" data-path="images/features/tables/tables-home.png" />
</Frame>

**Where each action lives in the UI** (for telling users where to click):

* **Tables home**: the **Tables** entry in the left nav sidebar (`/table`) — a searchable list across the data grid with **Name**, **Type** (Table or View), **Column** count, **Source**, and **Last refreshed** columns, plus **type filter chips** (All, Summation, and one per connector: Snowflake, Redshift, Iceberg, S3, Oracle). A **Create** menu at the top-right makes a **Data**, **Calculation**, **Dimension**, or **Source** table, or a folder. `/table` replaces the old `/data` and `/model/tables` pages.
* **Open a table**: click a row to open its grid at `/table/{tableId}`; **Views** and **Export CSV** are in the grid's toolbar.
* **Kinds vs. type**: the four kinds you create (Data, Calculation, Dimension, Source) are all **Summation** tables. **Connector tables** aren't created here — they arrive through [connectors](/features/connectors) and appear filtered under their connector's type chip.

<Warning>
  The Tables page is gated by feature flags — `ui_data_home_v1` (the page itself), `ui_data_home_csv_import` (the Source Table option and importer), and `ui_data_home_sidebar` (the Data files sidebar); with one of these off, that part won't appear. The `ui_data_browser_table_freshness` flag only changes the freshness column's label — on, it reads **Last refreshed**; off, it falls back to **Last modified**. The column stays either way.
</Warning>

## Find and open a table

<Tabs sync={false}>
  <Tab title="In the app">
    The **Tables** page (`/table`, shown above) lists every table and view in the data grid. Filter by source with the type chips (Summation or a connector), search within a folder, and click a table to open its grid. In the grid you can browse rows, apply **Views** and filters, and **Export CSV**.

    <Frame caption="An open table">
      <img src="https://mintcdn.com/summation-676748f5/ewrpxeNnW54PEh54/images/features/tables/table-overview.png?fit=max&auto=format&n=ewrpxeNnW54PEh54&q=85&s=d1bfb07333fbc810270f80130cf1ccd5" alt="An open table 'olympics_event' shown as a spreadsheet grid with typed columns (ID, Name, Sex, Age, Height, Weight, Team, NOC, Games, Year, Season), a Views dropdown, an Add Filter control, and an Import button." width="2938" height="1942" data-path="images/features/tables/table-overview.png" />
    </Frame>
  </Tab>

  <Tab title="Via the API">
    <Card title="GET /v1/tables" icon="code" href="/api-reference/tables/list-tables" horizontal>
      List tables in the data grid.
    </Card>

    <Card title="GET /v1/tables/{tableId}" icon="code" href="/api-reference/tables/show-table" horizontal>
      Show a table's definition — its columns, types, and source, plus an `appendable` annotation for whether it accepts row appends. (Catalog metadata is a separate endpoint, below.)
    </Card>

    <Card title="GET /v1/tables/{tableId}/data" icon="code" href="/api-reference/tables/fetch-table-data" horizontal>
      Preview a table's rows.
    </Card>
  </Tab>
</Tabs>

## Create a table

Use **Create** (top-right of `/table`) to make a Summation table. Each kind has its own page:

| Table kind            | Type                                                                                           | Guide                                              |
| --------------------- | ---------------------------------------------------------------------------------------------- | -------------------------------------------------- |
| **Data table**        | `TableType` `DATA`                                                                             | [Data tables](/features/tables/data)               |
| **Source table**      | Not a `TableType` — a `FILE_IMPORT` source table, created via its own `CreateSourceTable` call | [Source tables](/features/tables/source)           |
| **Calculation table** | `TableType` `CALCULATION`                                                                      | [Calculation tables](/features/tables/calculation) |
| **Dimension table**   | `TableType` `DIMENSION`                                                                        | [Dimension tables](/features/tables/dimension)     |
| **Connector table**   | Connector-backed (external)                                                                    | [Connectors](/features/connectors)                 |

<Frame caption="The Create menu">
  <img src="https://mintcdn.com/summation-676748f5/ewrpxeNnW54PEh54/images/features/tables/create-menu.png?fit=max&auto=format&n=ewrpxeNnW54PEh54&q=85&s=7bdd649b65d04e4623a918177de843eb" alt="The Create menu on the Tables page, headed 'Summation', with Data Table, Calculation Table, Dimension Table, Source Table, and New Folder." width="510" height="588" data-path="images/features/tables/create-menu.png" />
</Frame>

## Catalog

<Tabs sync={false}>
  <Tab title="In the app">
    Every table and view carries a **catalog** — the metadata that describes it and its columns, and what [Addison](/features/addison) reads to understand your data. Open it from the **Catalog** button (book icon) in a table's toolbar.

    * **Table**: a **description**, **owner**, **source system**, and an **agent description** written for Addison (what the entity contains and when to use it). (A table also has a **modeling tier**, but it's set through the API only — it isn't shown or editable here.)
    * **View**: only a **description**, **owner**, and **agent description**.
    * **Columns**: a description and an agent description each.

    In the panel, the **Context** tab shows the agent-facing **System Description** with a **User Defined** override you can edit; the **Columns** tab edits per-column descriptions. A standalone **Data Catalog** home browses all of it across the grid.

    Because Addison relies on it, richer catalog metadata (especially agent descriptions) directly improves its answers. Separately, a [project](/features/projects) attaches specific tables and views to its catalog to control what Addison can see there; an empty project catalog means the agent has no data context.

    <Frame caption="The Catalog panel — Columns tab">
      <img src="https://mintcdn.com/summation-676748f5/ewrpxeNnW54PEh54/images/features/tables/catalog-panel.png?fit=max&auto=format&n=ewrpxeNnW54PEh54&q=85&s=3cad2a280f20e7cfee58bc0fbf0666fd" alt="The Catalog panel for the table 'olympics_event', showing Created / Created by / Updated / Updated by metadata and Context, Columns (15), and Lineage tabs. The Columns tab lists each column with an editable description — ID reads 'Player ID', Name is being edited with a description field and Cancel / Save, and others (Sex, Age, Height, Weight, Team, NOC) show 'Add a description...'." width="2954" height="1962" data-path="images/features/tables/catalog-panel.png" />
    </Frame>
  </Tab>

  <Tab title="Via the API">
    <Card title="GET /v1/tables/catalog" icon="code" href="/api-reference/tables/list-table-catalog" horizontal>
      List table catalog metadata across the tenant.
    </Card>

    <Card title="GET /v1/tables/{tableId}/catalog" icon="code" href="/api-reference/tables/show-table-catalog" horizontal>
      Show a table's catalog.
    </Card>

    <Card title="PATCH /v1/tables/{tableId}/catalog" icon="code" href="/api-reference/tables/update-table-catalog" horizontal>
      Update a table's catalog (description, owner, source system, modeling tier, agent description).
    </Card>
  </Tab>
</Tabs>

## Lineage

<Tabs sync={false}>
  <Tab title="In the app">
    Open **Lineage** from the table toolbar (or the Catalog panel's **Lineage** tab) to see what a table is built from and what depends on it — a graph linking source tables to the [calculation tables](/features/tables/calculation) and views derived from them. Expand a node's **View columns** for column-level lineage, and search for a table or column.

    <Frame caption="Table lineage">
      <img src="https://mintcdn.com/summation-676748f5/ewrpxeNnW54PEh54/images/features/tables/lineage.png?fit=max&auto=format&n=ewrpxeNnW54PEh54&q=85&s=834dc0f027a6de6317082c77ea51b6aa" alt="A lineage graph for 'olympics_event' with a 'Search Tables and Columns' box and several table nodes — customer_revenue_form..., memgrizz, and the calculation tables (fx) sales_by_category_wow..., top_sales_by_category_w..., and weekly_sales_by_category — each showing its column count and a 'View columns' expander, with a line connecting sales_by_category_wow... to weekly_sales_by_category." width="2238" height="1158" data-path="images/features/tables/lineage.png" />
    </Frame>
  </Tab>

  <Tab title="Via the API">
    <Card title="GET /v1/grid/tables/{tableId}/lineage" icon="code" href="/api-reference/grid/show-table-lineage" horizontal>
      Show a table's lineage.
    </Card>
  </Tab>
</Tabs>

## Delete a table

<Tabs sync={false}>
  <Tab title="In the app">
    There's no delete action in the Tables UI. A table row's actions are **Open data catalog**, **Open in new tab**, **Copy link**, **Find in folder**, and **Rename** — none of them delete. Deleting a table is API-only (see **Via the API**) or done through admin tooling, and can't be undone.
  </Tab>

  <Tab title="Via the API">
    <Card title="DELETE /v1/tables/{tableId}" icon="code" href="/api-reference/tables/delete-table" horizontal>
      Delete a table. Requires the `agent:write` scope and `confirm=true` (a `400` otherwise); optional `force` and `metadata_only` query params.
    </Card>
  </Tab>
</Tabs>
