Databricks SQL row limits

bigkahunaburger
New Contributor II

hi there,
my dataset is approx 408K rows. i am trying to run a query that will return everything. but the results set seems to stop at 64K rows.
i've seen a few posts in here asking about it, but they are several years old and a solution is promised. but nothing seems to have been updated on the row limitations.
is there a setting that i am missing to allow >64K rows?
or is it still locked at 64K rows?
if this is the case, is there any potential solution for this?
i like databricks. i dont want to have to go back to Athena 🙁
Thanks guys