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.
- 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?
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.
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
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.