Limiting data

Sometimes, to speed up the process of exploring data, you only want to see a subset of your complete results from your query. You can do this in Holistics by using our Row Limit feature:

Without a set row limit, Holistics supports up to 1,000,000 rows for Data Exploration / Report Creation and 100,000 rows for Data Modeling Preview. When you set a row limit, Holistics will only display up to the number of rows you have set, and let you know about your incomplete results.

  • The Row Limit is directly applied on your query.
  • Our sort order is important in these situations: Holistics will first applies the limit, and then applies the sort.