27

Allow more than 10,000 rows for SQL queries


Avatar
Sandra

SQL queries in Databox are currently limited to 10,000 rows.

The request is to increase the limit above 10,000 rows.

Voters on this post, please share your use case, along with the number of rows you'd need for successful reporting in Databox.

For example:
- Would you need a higher row limit just one time to sync all historical data into Databox?
- Or would you need a higher row limit on a regular basis due to having more than 10,000 new rows of SQL data per day?

A

Activity Newest / Oldest

Avatar

Waleed Almarshidi

Couldn't Cover the whole year of sales even after grouping and cleaning data ): so sad


Avatar

Ben Ridler

This makes databox limited in the ecom, larger company space. Workarounds are possible, but don't support best practice. Another option is to have a one-off historic import for a metric then the 10,000 limit only applies to updates.


B

Brian Rodricks

+1 To increase the data limit. Already grouping data as must as possible and cannot get a full year loaded because of this limit. The error message returned by Databox just said 'Invalid Setup' which is way too vague. This also forces me to add limits to the metrics to get them to run. Databox should be auto adding the limit and generate a message when the limit is reached so as to avoid metrics that are working, randomly stopping with an error when the underlying data reaches the limit.


  • T
Avatar

Anthony Emeka Nwankwo

User had a need for more than 10,000 rows.


S

Simon Kocher

Increase the limit of 10,000 rows on the query results that are sent from the underlying Data Source. For companies with more data it is impossible to query all figures of a year to get an overview.
Increasing this number would not only give customers a better and longer time horizon for evaluations, it would also make Databox more attractive to larger young and modern companies that work mainly with web applications.

Comparable tools, such as Power Bi, have multiple maximum number of lines that can process Databoxes in a query.


Avatar

Sandra

Merged with: Increase the query results row limit

Avatar

Sandesh Phuyal

Hey,

I am using SQL queries, and we have data from 2019 till 2021 which is more than 10,000 rows. Is there a way we can increase the limit from 10k to 100k? If I set limit as 100,000 it returns me 0 as values.


Avatar

Sandra

Hi Sandesh,

Thanks for sharing your use case.

Currently, there is no way to increase this limit.
An alternative solution could be grouping data on your end or using GROUP BY in the SQL code to decrease the number of rows returned.

Does this help?

Sandra from Databox


N

Nick Moers

I would need a higher row limit just one time, to sync all historical data into Databox.
Especially because the function to keep the data when running a query was removed.