https://community.databricks.com/t5/data-engineering/rest-api-to-execute-sql-query-and-read-output/m-p/21952#M14997 <P>Hi there,</P><P></P><P>I'm using these two APIs to execute SQL statements and read output back when it's finished. </P><P>However, seems it always returns only 1000 rows even though I need all the results (millions of rows), is there a solution for this? </P><P></P><UL><LI>execute SQL: <A href="https://docs.databricks.com/dev-tools/api/1.2/index.html#run-a-command" target="test_blank">https://docs.databricks.com/dev-tools/api/1.2/index.html#run-a-command</A></LI><LI>read output: <A href="https://docs.databricks.com/dev-tools/api/1.2/index.html#get-information-about-a-command" target="test_blank">https://docs.databricks.com/dev-tools/api/1.2/index.html#get-information-about-a-command</A></LI></UL><P></P><P>Thanks!</P><P></P> Thu, 28 Apr 2022 06:25:17 GMT shawncao 2022-04-28T06:25:17Z https://community.databricks.com/t5/data-engineering/rest-api-to-execute-sql-query-and-read-output/m-p/21952#M14997 <P>Hi there,</P><P></P><P>I'm using these two APIs to execute SQL statements and read output back when it's finished. </P><P>However, seems it always returns only 1000 rows even though I need all the results (millions of rows), is there a solution for this? </P><P></P><UL><LI>execute SQL: <A href="https://docs.databricks.com/dev-tools/api/1.2/index.html#run-a-command" target="test_blank">https://docs.databricks.com/dev-tools/api/1.2/index.html#run-a-command</A></LI><LI>read output: <A href="https://docs.databricks.com/dev-tools/api/1.2/index.html#get-information-about-a-command" target="test_blank">https://docs.databricks.com/dev-tools/api/1.2/index.html#get-information-about-a-command</A></LI></UL><P></P><P>Thanks!</P><P></P> Thu, 28 Apr 2022 06:25:17 GMT https://community.databricks.com/t5/data-engineering/rest-api-to-execute-sql-query-and-read-output/m-p/21952#M14997 shawncao 2022-04-28T06:25:17Z