Configuration property xyz.dfs.core.windows.net not found

Question

I am trying to connect to Linked SQL Pool from azure synapse notebook:

 val df = spark.read.
    option(Constants.SERVER, "wrk-pr-us-xyz.sql.azuresynapse.net").
    option(Constants.USER, "xyzuser").
    option(Constants.PASSWORD, "xxxxxx").
    sqlanalytics("Product_Pool1.dbo.tblOtoSuiteMaster")
    df.show()

But I get below error:
Error: com.microsoft.spark.sqlanalytics.exception.SQLAnalyticsConnectorException: com.microsoft.sqlserver.jdbc.SQLServerException: External file access failed due to internal error: 'Error occurred while accessing HDFS: Java exception raised on call to HdfsBridge_Connect. Java exception message:
Configuration property xyzssdatawarehouse01.dfs.core.windows.net not found.'

I referred this link but no luck.
I can access the sql pool using SSMS and same credentials.

Answer 1

Hi,
is there any solution for this yet?
I'm trying to set up the connection in Synapse Notebooks
val df = spark.read.
option(Constants.SERVER, "wrk-pr-us-xyz.sql.azuresynapse.net").
option(Constants.USER, "xyzuser").
option(Constants.PASSWORD, "xxxxxx").
sqlanalytics("Product_Pool1.dbo.tblOtoSuiteMaster")
df.show()

and I'm getting the same error. Could you please give any advice on this matter?