Forum Discussion
Databricks Connection Fails Only in Fabric Pipeline
Hello all! I am trying to create a Pipeline to get data from my Azure Databricks environment. I have an existing connection that I have used with Dataflows and Semantic Models before that works w...
BeaBF
Super User
Super UserAKemper It's true.
1. JDBC URL
Enter the URL without UID/PWD:
jdbc:spark://<ServerHostname>:443/default;transportMode=http;ssl=1;httpPath=<HTTPPath>;AuthMech=3
(notice no UID/PWD)
2. Username field
Put literally the string:
token
3. Password field
Put your Databricks Personal Access Token here.
4. Authentication type
Choose Basic authentication (even though it’s token-based — this is how Databricks expects it).
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
BeaBF I am getting a different error now regarding ODBC drivers.
Error message:
An exception occurred: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I am seeing conflicting comments online about how to resolve this so any thoughts you have regarding this would be appreciated.
Thanks!
- BeaBF
AKemper have you still the problem?
You’re no longer hitting Databricks-side auth issues; you’re now hitting a driver problem on the ADF/Synapse side.
Use the JDBC connector instead of ODBC(Recommended, no driver installation needed)
-
In ADF Linked Services, choose JDBC (not ODBC).
-
Connection string:
jdbc:spark://<ServerHostname>:443/default;transportMode=http;ssl=1;httpPath=<HTTPPath>;AuthMech=3 -
Username: token
-
Password: <your Databricks PAT>
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
-
