topic Re: Databricks SQL restful API to query delta table in Warehousing & Analytics

Databricks SQL restful API to query delta table

sensanjoy — Mon, 27 Feb 2023 17:27:51 GMT

As of today, can we use any Databricks SQL Restful API to query Delta Tables stored in ADLS from any external UI?

There is some information mentioned over this link https://docs.databricks.com/sql/api/index.html? but not sure how to use them!!

Checked in Databricks documentation about how this can be implemented but dint find any proper way out.

Any help/suggestion is highly appreciated.

Re: Databricks SQL restful API to query delta table

daniel_sahal — Tue, 28 Feb 2023 06:23:53 GMT

@[sensanjoy]

I don't think that there's a way to query a Delta Table to get the data through REST API.

Re: Databricks SQL restful API to query delta table

youssefmrini — Tue, 28 Feb 2023 11:02:23 GMT

As far as I know we don't have any rest Delta Rest API

Re: Databricks SQL restful API to query delta table

NateAnth — Tue, 28 Feb 2023 14:10:58 GMT

Databricks SQL has many ways to query data programatically. Last year we published a blog outlining a options for connectors for Go, Node.js, Python, as well as a new CLI that makes it simple for developers to connect to Databricks SQL from any application of their choice.

https://www.databricks.com/blog/2022/06/29/connect-from-anywhere-to-databricks-sql.html

There is a SQL API for submitting queries to Databricks SQL Warehouses currently in preview. Please reach out to your Databricks account team to see if it makes sense to explore the preview for your use case.

Re: Databricks SQL restful API to query delta table

sensanjoy — Wed, 01 Mar 2023 08:27:10 GMT

Thanks NateAnth for the information.

Re: Databricks SQL restful API to query delta table

sensanjoy — Wed, 01 Mar 2023 08:28:07 GMT

yup...you are right.

Re: Databricks SQL restful API to query delta table

Anonymous — Tue, 07 Mar 2023 07:17:25 GMT

Hi @Sanjoy Sen

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Re: Databricks SQL restful API to query delta table

apingle — Tue, 07 Mar 2023 22:36:11 GMT

I just saw this today..

https://www.databricks.com/blog/2023/03/07/databricks-sql-statement-execution-api-announcing-public-preview.html

Re: Databricks SQL restful API to query delta table

NateAnth — Wed, 08 Mar 2023 01:19:04 GMT

This is the feature I was referring to above. It is now in public preview. Enjoy!

Re: Databricks SQL restful API to query delta table

sensanjoy — Wed, 08 Mar 2023 05:10:11 GMT

excellent 🙂

Re: Databricks SQL restful API to query delta table

sensanjoy — Wed, 08 Mar 2023 05:12:45 GMT

Hi Vidula..I am good to close this as I have received the solution looking for answered by @Nathan Anthony and @Anant Pingle .