by
juanc
• New Contributor II
- 2590 Views
- 9 replies
- 2 kudos
It would be possible to activate a custom extensions like Sedona (https://sedona.apache.org/download/databricks/ ) in SQL Endopoints?Example error:java.lang.ClassNotFoundException: org.apache.spark.sql.sedona_sql.UDT.GeometryUDT at org.apache.spark....
- 2590 Views
- 9 replies
- 2 kudos
Latest Reply
@Kaniz What is the right way to add custom spark extension to sql warehouse clusters?
8 More Replies
- 1144 Views
- 2 replies
- 3 kudos
Do Serverless SQL Endpoints benefit from Delta and Spark Cache? If so, does it differ from a non-serverless endpoints? How long does the cache last?
- 1144 Views
- 2 replies
- 3 kudos
Latest Reply
Hi @Mike Gardner​ , How are you doing? Was your query resolved? Do you need more help on the same?
1 More Replies
- 1197 Views
- 4 replies
- 5 kudos
Serverless SQL Endpoints sound exciting! Sounds like they've been in preview on AWS for a couple months. Any idea if/when they're coming to Azure?
- 1197 Views
- 4 replies
- 5 kudos
Latest Reply
Hi @snarfed​ , A SQL endpoint is a computation resource that lets you run SQL commands on data objects within Databricks SQL. This article introduces SQL endpoints and describes how to work with them using the Databricks SQL UI. A SQL endpoint is a t...
3 More Replies
by
Manoj
• Contributor II
- 6610 Views
- 4 replies
- 8 kudos
Is there a way to submit multiple queries to data bricks SQL END POINT using REST API ?
- 6610 Views
- 4 replies
- 8 kudos
Latest Reply
@Manoj Kumar Rayalla​ DBSQL currently limits execution to 10 concurrent queries per cluster so there could be some queuing with 30 concurrent queries. You may want to turn on multi-cluster load balancing to horizontally scale with 1 more cluster for...
3 More Replies
- 621 Views
- 1 replies
- 0 kudos
Basically I'm worried about the scenario where data that gets cached on Databricks SQL endpoints becomes out of sync with the source Delta table. If that were to happen and data was read from the cache it would be out of date/incorrect. Is this a con...
- 621 Views
- 1 replies
- 0 kudos
Latest Reply
There are 3 types of caching. 1-Databricks SQL UI caching, 2-Query results caching , 3-Delta caching . (1) does not get invalidated. It's like your BI dashboard. BI dashboard needs to be manually refreshed.(2) and (3) gets auto invalidation.pls check...
- 972 Views
- 1 replies
- 0 kudos
I see the option to enable multi-cluster load balancing when creating a SQL Endpoint, but I don't know if I should be using it or not. How do I know when I should enable it?
- 972 Views
- 1 replies
- 0 kudos
Latest Reply
It is best to enable multi-cluster load balance on sql endpoints when a lot of users will be running queries concurrently. Load balancing will help isolate the queries and ensure the best performance for all users. If you only have a few users runnin...
- 375 Views
- 0 replies
- 0 kudos
Muti Cluster Load balancingMulti-cluster Load Balancing: the minimum and maximum number of clusters over which queries sent to the endpoint are distributed. The default is Off with a maximum of 1 cluster. When set to On, the default is minimum 1 clus...
- 375 Views
- 0 replies
- 0 kudos
- 570 Views
- 1 replies
- 2 kudos
Where do Databricks SQL endpoints run?
- 570 Views
- 1 replies
- 2 kudos
Latest Reply
Like Databricks clusters, SQL endpoints are created and managed in your Cloud Account (like GCP,AZURE,cloud). SQL endpoints manage SQL-optimized clusters automatically in your account and scale to match end-user demand.