I am using export DSE to Excel smart service, but the output data is not the full data the Table is having.
I am having around 21k data in table where as the excel that was generated through the smart service is having only 20k rows.Are there any limitations for smart service?
Discussion posts and replies are publicly visible
Yes.We can Only Fetch 20k recorrs and In Grid Also We have same limitation while donwloding the data from Grid
I think the limitation is more around the amount of rows that Excel can handle. (1,048,576 rows).
I was able to generate an excel file with 1M rows with no issues.
I agree with Mathieu's comment , It's more about the size and query time it took to get the data . Are you sure you don't have any filters on the file ??And is it getting first 20k rows??