topic Databricks sql API <- Delta tables in Get Started Discussions

Databricks sql API <- Delta tables

Ruby8376 — Mon, 22 Apr 2024 14:50:55 GMT

We have an integration flow where we want to expose databricks data for querying through odata(webapp). For this piecedatabricks sql API <- Delta tables :

2 questions here:

1. can you share link/documentation on how we can integrate databricks <-delta tables? do we need serverless sql warehouse for sure for querying??

2. For authentication, we have chosen Oauth machine to machine authentication as per microsoft recommendation. in this process do we use external table to share the same delta table? OAuth machine-to-machine (M2M) authentication | Databricks on AWS

Re: Databricks sql API <- Delta tables

shan_chandra — Mon, 22 Apr 2024 17:19:44 GMT

Hi @Ruby8376 - can you please review the similar posts where the resolution is provided

https://community.databricks.com/t5/warehousing-analytics/databricks-sql-restful-api-to-query-delta-table/td-p/8617

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

Re: Databricks sql API <- Delta tables

Ruby8376 — Mon, 29 Apr 2024 19:43:47 GMT

Were you able to implement it?

@shan_chandra