Default rows returned

[jmetape]

Hi, How do I change the default number of rows returned in a sql query? There are only 20 rows returned in my queries.

[juanbstevens]

I'm having the exact same frustration. The previous suggestion people gave
#!set --name notebook.output.textLineLimit --value 1000

is not working unfortunately. It seems like there used to be a special viewer that displayed the results in a better way but that isn't used anymore. It seems the ball has been dropped.

[jonsequitur]

What you're seeing here is a display setting. As you can see from the output, your query returned thirty rows, but only 20 are displayed. This is the default value for Formatter.ListExpansionLimit but you can change it in order to display more results:

You can read more about related APIs here: https://github.com/dotnet/interactive/blob/main/docs/formatting.md