- 10122 Views
- 4 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...
- 10122 Views
- 4 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
- 4362 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?
- 4362 Views
- 3 replies
- 9 kudos
- 962 Views
- 0 replies
- 0 kudos
- 962 Views
- 0 replies
- 0 kudos
- 1576 Views
- 0 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...
- 1576 Views
- 0 replies
- 0 kudos
- 1678 Views
- 2 replies
- 0 kudos
- 1678 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
- 1624 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?
- 1624 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
- 922 Views
- 0 replies
- 1 kudos
- 922 Views
- 0 replies
- 1 kudos