Hi I am query my Azure Databricks table using VB script/Simba Spark ODBC driver.

While querying into the DB(lets say 'Select * from table_1') it is not returning any data. However while querying a limit (lets say 'Select TOP 10000 ID from table_1'), it is giving me the first 10000 rows. The table has 50k rows and I want all them at once due to some limitation at target system