I typically run SELECT * FROM ... just to get a peak on the data and in many cases forget to add limit (yeah I know I know....) .

It would be nice if REDASH would have tunable default limit e.g. 10,000 rows (same way most of the desktop tools like TOAD or Navicat have). Not sure if this is easy to do for any data sources, its certainly trivial for postgres (it executes the limit as a last step).

Ideally displayed on the new query page right next to "refresh schedule". This way user knows about it and can easily change it.