Aggregate Table
https://{your-workspace-slug}.{region}.xata.sh/db/db_branch_name/tables/table_name/aggregate
Expected parameters
Name | Description | In | Required | Schema |
---|---|---|---|---|
db_branch_name | The DBBranchName matches the pattern `{db_name}:{branch_name}`. | path | ✅ | string |
table_name | The Table name | path | ✅ | string |
Run Aggregations Over a Table
POSThttps://{your-workspace-slug}.{region}.xata.sh/db/db_branch_name/tables/table_name/aggregate
This endpoint allows you to run aggregations (analytics) on the data from one table. While the summary endpoint is served from a transactional store and the results are strongly consistent, the aggregate endpoint is served from our columnar store and the results are only eventually consistent. On the other hand, the aggregate endpoint uses a store that is more appropriate for analytics, makes use of approximation algorithms (e.g for cardinality), and is generally faster and can do more complex aggregations.
For usage, see the Aggregation documentation.