Databricks Truncates Rows in SQL

1

SQL query should give a result of 100,000 rows but the output is truncated and only displays 64,000 rows. How is this corrected to show 100,000 rows.

image