REST api to execute SQL query and read output

[shawncao]

Hi there,

I'm using these two APIs to execute SQL statements and read output back when it's finished.

However, seems it always returns only 1000 rows even though I need all the results (millions of rows), is there a solution for this?

• execute SQL: https://docs.databricks.com/dev-tools/api/1.2/index.html#run-a-command
• read output: https://docs.databricks.com/dev-tools/api/1.2/index.html#get-information-about-a-command

Thanks!