how can i get download size for CSV/XLSX to be maximum or without limitation on it?
There’s no limit on the size (amount of MB) - as far as I know.
The only limitation is number of rows, which is hardcoded to 1 million of downloads.
You would need to change the source and build your own version to get around the limitation.
I really like if possible control this per db connection in collection
My use case for this: big query connection with no limit problems and sqlsever with limited resources
Another possibility is offload data generation and send email when finish the job