Am I right in assuming that all filtered data records are taken into account in a table aggregation and not just within the range of the maximum limit of 1,000 data records? Thanks Ralf

I was wondering the same today ! Did anyone test this or maybe someone at tulip has the answer ?

Hi @RalfMueller and @pte , thanks for bringing this up! Right now the limit of 1000 records does affect the table aggregation. Because the aggregations are run on queries, so the aggregation result will depend on the limit you’ve set for the query.

Thanks you for the clarification @ZixuanLi . I’m concerned about this limit now. Is there any plan to raise it ? Before the aggregation I was using the Table API, it was cumbersome but there was no limit. [image]

I’m also concerned about the record limit, my company is wanting to hang on to at least 10 years worth of data for some tables.

@ZixuanLi Are there any plans to raise the limit on query limits?

Aggregation and limit

Support, Troubleshooting, & Help

RussWaddell January 23, 2023, 6:50pm 7

Closing this to consolidate with more recent related discussion. Please refer to the product suggestion topic Table Aggregations on whole Table / Querie limit 1000 for further discussions, voting, and status reporting from the Tulip team.

Topic		Replies	Views
Table Aggregations on whole Table / Querie limit 1000 Product Suggestions table-queries , table-aggregations	31	2346	April 12, 2024
Too many triggers in a row Support, Troubleshooting, & Help tulip-tables , triggers	4	149	August 27, 2025
Increase API limit of 100 records per call Product Suggestions api , table-api	2	82	May 18, 2026
Unique Values from Table w/ >1000 Records? Support, Troubleshooting, & Help unique-values , aggregation , analysis	2	233	February 1, 2024
Sort Table Aggregations Product Suggestions	1	370	August 27, 2025

Aggregation and limit

Related topics