- 9028 Views
- 5 replies
- 3 kudos
Connect to Databricks SQL Endpoint using Programming language
Hi, I would like to know whether there is a feasibility/options available to connect to databricks sql endpoint using a programming language like java/scala/c#. I can see JDBC URL, but would like to whether it can be considered as any other jdbc conn...
- 9028 Views
- 5 replies
- 3 kudos
- 3 kudos
I found a similar question on Stackoverflow https://stackoverflow.com/questions/77477103/ow-to-properly-connect-to-azure-databricks-warehouse-from-c-sharp-net-using-jdb
- 3 kudos
- 3790 Views
- 3 replies
- 9 kudos
Resolved! Databricks SQL Endpoint start times
When I first login and start using Databricks SQL, the endpoints always take a while to start. Is there anything I can do to improve the cold start experience on the platform?
- 3790 Views
- 3 replies
- 9 kudos
- 1487 Views
- 1 replies
- 0 kudos
What are the Best Practices for SQL Endpoint sizing?
I see that cluster sizes are mentioned here https://docs.databricks.com/sql/admin/sql-endpoints.html#cluster-size but I would like to know when to pick what type of cluster (data size/ users/ concurrency) without having to do too much trial and error...
- 1487 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @ MoJaMa ! 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 on the Forum have an answer to your question first. Or else I will follow up shortly with a response.
- 0 kudos
- 842 Views
- 0 replies
- 0 kudos
- 842 Views
- 0 replies
- 0 kudos
- 1562 Views
- 2 replies
- 0 kudos
- 1562 Views
- 2 replies
- 0 kudos
- 0 kudos
When sizing, this is the recommendation. Data set Cluster SizeITB / rows X-Large+500GB / 1B rows X-LargeSOGB / IOOM+ rows LargeIOOGB / rows MediumIOGB / -M rows SmallThis table maps SQL endpoint cluster sizes to Databricks cluster driver sizes and wo...
- 0 kudos
- 1220 Views
- 1 replies
- 0 kudos
Resolved! Should I enable Photon on my SQL Endpoint?
I see the option to enable Photon when creating a new SQL Endpoint. The description says that enabling it helps speed up up queries, which sounds good, but are there any downsides I need to be aware of?
- 1220 Views
- 1 replies
- 0 kudos
- 0 kudos
Generally, yes you should enable photon. The majority of functionality is available and will perform extremely well. There are some limitations with it that can be found here. Limitations: Works on Delta and Parquet tables only for both read and writ...
- 0 kudos
- 886 Views
- 0 replies
- 1 kudos
- 886 Views
- 0 replies
- 1 kudos