SNOW-650150: Add some indication to `DataFrame.show()` that it isn't all the results about snowpark-python HOT 3 OPEN

Hey @mbkupfer thanks for your suggestion. I think option 1 is better that we will add one line saying how many rows are displayed, but probably will not count the total rows in this dataframe since it needs another call to count(), which might not be efficient. Option 2 might make users confused because pandas' head is to return n rows, instead of print n rows.

from snowpark-python.

We had to solve this in https://github.com/ibis-project/ibis and it's not particularly bad. You don't need two calls: you can execute a limit with N+1 rows where N is the number of rows to show and the check whether the number of returned rows is greater than N.

Ibis has great snowflake support, so if anyone is interested in a DataFrame API with a nice indicator of "more rows" check it out!

from snowpark-python.

@cpcloud I'll take a look at the project. Thanks for sharing.

from snowpark-python.