Hello Team,
I am trying to read the data from Synapse analytics from databricks.The below is the Query to read the table.
%python
### Read from Azure Synapse table via spark.read.load
df = spark.read \
.format("com.databricks.spark.sqldw") \
.option("url", f"jdbc:sqlserver://xyz.sql.azuresynapse.net:1433;database=Bronze;user=svc_datalakehouse@abc.com;password=qKfb5;encrypt=false;trustServerCertificate=true;hostNameInCertificate=xyz.sql.azuresynapse.net;loginTimeout=60;")\
.option("tempDir", "abfss://xyz@xyz.dfs.core.windows.net/temp") \
.option("forwardSparkAzureStorageCredentials", "true") \
.option("dbTable", tableName) \
.load()
I am getting error :
Azure Synapse Analytics failed to execute the JDBC query produced by the connector.
Underlying SQLException(s):
- com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open server "abc.com" requested by the login. The login failed. ClientConnectionId:0995d0ab-c56d-40ac-8fc5-ac514083e38c [ErrorCode = 40532] [SQLState = S0001]
Please advise the solution.
Regards
Rohit