[benmcredmond]

Thanks!

Today we have a cap of 200k rows per sheet – this is a level where we feel performance is acceptable. We actually just doubled the limit from 100k and we have a plan to get to 1M rows by EOY. Definitely some meaty performance work here but it's tractable.

For SQL querying, you set up a connection to your SQL database in Equals and then we pass queries to your database. Query results are copied into the spreadsheet where you can use full spreadsheet formulas, pivots, etc. against it.