Abhishek-kumar-samsung opened a new pull request, #33204:
URL: https://github.com/apache/superset/pull/33204

   Earlier in SQL lab we had limited options to use as **limit of number of 
rows in sql results**. These options were only [10,100,1000, 10000, 100000]
   
   Earlier it used to look like : 
   ![107 99 237 104_8013_sqllab_ 
(3)](https://github.com/user-attachments/assets/68103cbd-76ad-435d-9dad-d32bb590364b)
   
   I have added an option to put your custom limit while fetching sql query 
results as below : 
   ![107 99 237 
104_8013_sqllab_](https://github.com/user-attachments/assets/70af61b0-dafe-427c-932e-05bd54cd4f82)
   ![107 99 237 104_8013_sqllab_ 
(1)](https://github.com/user-attachments/assets/12ae0f18-e01b-4aae-9e7a-33d8dcb1bfea)
   ![107 99 237 104_8013_sqllab_ 
(2)](https://github.com/user-attachments/assets/3323c7ef-1655-4d55-aacf-611772e5352c)
   
   One can put their custom limit in input text and hit enter, and that limit 
will be applied while fetching number of rows in sql results.
   
   
   **Use cases:**
   Actually earlier once for me requirement came to fetch 700 results, so i had 
two options to complete the task i.e (put limit 700 in query itself, but in 
that case this limit feature does not makes any sense, it becomes useless), and 
second way is fetch 1000 results, then download csv and then remove 300 
rows(but this results in lot of overhead)
   -> To resolve above drawbacks this feature of custom limit is helpfull.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to