> ## 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 & views > Read, write, and compute Summation tables and views over the API. Summation tables come in several flavors: hand-authored data tables, connector-backed source tables, computed calculation and dimension tables, and views over them. The API surface splits across three areas: `/v1/tables` for tables and rows, `/v1/views` for views, and `/v1/grid` for the computed graph. Row appends and ingestion batches need the `tables:append` scope, not `agent:write` (see [Authentication](/api/authentication#scopes)). Product-side docs: [Tables](/features/tables). ## Find and open a table List tables in the data grid. 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.) Preview a table's rows. ## Catalog List table catalog metadata across the tenant. Show a table's catalog. Update a table's catalog (description, owner, source system, modeling tier, agent description). ## Lineage Show a table's lineage. ## Delete a table Delete a table. Requires the `agent:write` scope and `confirm=true` (a `400` otherwise); optional `force` and `metadata_only` query params. ## Create a calculation table Create a calculation table from a SELECT query. This is the default (`kind: "calc"`); the same route also creates [data tables](/features/tables/data) with `kind: "data"`. Materialize the table so it can be queried. Refresh it from the latest source data. ## Create a data table Create an empty data table from a column schema with `kind: "data"` and `columns`. The API adds an integer `s_id` primary key and an `_sm_created_at` timestamp for you, so don't declare them. The id it returns accepts appends immediately. Use this rather than [`POST /v1/table-imports`](/api-reference/tables/create-table-import), which loads a table from an uploaded file and produces an import table that does *not* accept appends. Append 1–500 rows per request; every row must include the table's primary key column(s) (a `400` otherwise). Returns `200` when all rows apply, `207` for a partial result, or `422`; a `409` means the table isn't promoted yet. Requires the `tables:append` scope. Upsert rows (insert or update by key), with the same 1–500 row limit and `tables:append` scope. Start a batched (multipart) ingestion for larger loads. Get a presigned URL to upload one part of a batch. Commit the batch to apply its rows. Abort a batch and discard its parts. Requires the `tables:append` scope and `confirm=true`. Check a batch's status. ## Create a source table Import a file into a new source table, or refresh an existing one: set `import_type` to `FULL_REFRESH` or `INCREMENTAL_REFRESH` to re-import into a table that already exists (the API counterpart of the refresh above). Poll an import's status. ## Create and manage List views (optionally for one table). Show a view's definition. Fetch a page of the view's rows. Delete a view. ## Catalog Show a view's catalog. Update a view's catalog (description, owner, agent description).