topic Re: Query Databricks SQL Endpoint Database from NodeJs in Data Engineering

Query Databricks SQL Endpoint Database from NodeJs

KrishnaWahi — Thu, 28 Apr 2022 13:54:59 GMT

I have my Databricks SQL Endpoint running, I have created many tables there using AWS S3 Delta. Now I want to query the Databricks SQL Endpoint from NodeJs. So It is possible ?

I tried to find and researched a lot but didn't get any useful tutorial for that.

Re: Query Databricks SQL Endpoint Database from NodeJs

shan_chandra — Mon, 02 May 2022 03:04:54 GMT

DBSQL does not provide access to running queries over a REST API currently.

Re: Query Databricks SQL Endpoint Database from NodeJs

KrishnaWahi — Wed, 04 May 2022 06:14:27 GMT

Thanks Shan for answering.

May I know when I can expect it to be ready ?

For example, In python we have "Databricks SQL Connector"

https://pypi.org/project/databricks-sql-connector/

For establishing the connection.

Looking for the same in Nodejs !?

Re: Query Databricks SQL Endpoint Database from NodeJs

BilalAslamDbrx — Fri, 13 May 2022 11:44:45 GMT

We are very interested in supporting two capabilities -- in fact these are being worked on already:

The ability to issue a SQL query over REST and track its status, retrieve results etc.
A NodeJS SDK for Databricks SQL

Keep an eye on our release notes 🙂