can't connect Databricks to Synapse

Bry 41 Reputation points

i'm trying to read a table created in synapse, this is my configuration

spark.conf.set("", "OAuth")
spark.conf.set("",  "org.apache.hadoop.fs.azurebfs.oauth2.ClientCredsTokenProvider")
spark.conf.set("", "<<APPLICATION CLIENT ID>>")
spark.conf.set("", "<<CLIENT SECRET VALUE>>")
spark.conf.set("", "<<DIRECTORY TENANT ID>>/oauth2/token")

# Defining a separate set of service principal credentials for Azure Synapse Analytics (If not defined, the connector will use the Azure storage account credentials)
spark.conf.set("", "<<APPLICATION CLIENT ID>>")
spark.conf.set("spark.databricks.sqldw.jdbc.service.principal.client.secret", "<<CLIENT SECRET VALUE>>")

storageAccount = "<<STORAGE-NAME>>"
containerName = "<<CONTAINER-NAME>>"
accessKey = "<<KEY>>"
jdbcURI = "<<jdbc:sqlserver://...>>"

spark.conf.set(f"{storageAccount}", accessKey)

tableDF = ("com.databricks.spark.sqldw").option("url", jdbcURI).option("tempDir", "abfss://").option("enableServicePrincipalAuth", "true").option("dbTable", tableName).load())


But, when I run the code, I have this error: com.databricks.spark.sqldw.SqlDWConnectorException: Exception encountered in Azure Synapse Analytics connector code

Are there any settings I am missing?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,884 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,302 questions
No comments
{count} votes

Accepted answer
  1. HimanshuSinha-msft 18,621 Reputation points Microsoft Employee

    Hello @Bry ,
    Thanks for the ask and using Microsoft Q&A platform .
    You have not mentioned as to if you are trying to connected for dedicted pool or on demand pool , but the below reply from @PRADEEPCHEEKATLA-MSFT does call out all the steps .

    Please do let me know how it goes .

0 additional answers

Sort by: Most helpful