best practice of using data bricks API

shawncao
New Contributor II

Hello,

I'm building a Databricks connector to allow users to issue command/SQL from a web app.

In general, I think the REST API is okay to work with, though it's pretty tedious to write wrap code for each API call.

[Q1]

Is there an official (or semi-official) client SDK out there I can use? (interested in NodeJS SDK).

[Q2]

Another specific question, if my SQL command produces huge results (> millions of rows), are all results included in one call of "/command/status"? is there a streaming API that we can read row by row instead to reduce the memory consumption?

Thanks for your help!