Skip to Content

Datamart APIs

Datamart APIs

Create, list, update and delete datamarts: the tables, columns, joins and tenancy that metrics query.

A datamart is a set of tables and columns from one datasource, with the joins between them and the tenancy that scopes each customer’s rows. You refer to a datamart by its name.

TaskEndpoint
Create a datamartPOST /api/v2/data-app/datamarts
List datamartsGET /api/v2/data-app/datamarts
Update a datamartPUT /api/v2/data-app/datamarts
Delete a datamartDELETE /api/v2/data-app/datamart

Before you start

  • You have a service token. See Authentication.
  • The datasource is connected and its schema is synced. A table that is not in the synced schema is refused. See Sync a datasource.

Older routes

POST /api/v2/data-app/datamart/create, /datamart/list and /datamart/delete still work. Use the routes above for new code. On /datamart/list, send isPagination as a JSON boolean: the string "false" turns paging on.

Next, describe the datamart with a semantic layer.

On this page