Query RestAPI end point in Databricks Standard Workspace

[Soma]

Do we have option to query delta table using Standard Workspace as a endpoint instead of JDBC

[Kaniz]

Hi @somanath Sankaran​ ! My name is Kaniz, and I'm the technical moderator here. Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question first. Or else I will get back to you soon. Thanks.

[Hubert-Dudek · Accepted solution]

Hi @somanath Sankaran​ I bet that you refer to SQL endpoints which is only available in Premium.

I think the best approach is register two workspaces one cheaper standard and use it for jobs, normal clusters.

One more expensive and use it just for sql endpoint and sql dashboards.

Notebook code between both cab be easy synced with repo and you can implement common metastore (list of schema, tables).

[Soma]

@Hubert Dudek​  Thanks got it

[Anonymous]

@somanath Sankaran​ - Would you be happy to mark @Hubert Dudek​'s answer as best if it resolved the problem? That helps other members who are searching for answers find the solution more quickly. 🙂