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

Dheeraj 351

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.

HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2021-07-27T00:06:29.013+00:00

Hello @Dheeraj ,
Thanks for the ask and using the Microsoft Q&A platform .

You mentioned " Linked SQL Pool" ? Can you please elaborater on this ?
Also I see that the you are trting to connect to serverless , this is in the workspace as the notebook or in a different workspace ?

Thanks
Himanshu
Dheeraj 351 Reputation points

2021-07-28T10:49:14.16+00:00

By 'Linked SQL Pool' I wanted to mean - It is a Dedicated SQL pool Linked in 'Data' section of Synapse studio. It is not serverless and it is not in different workspace either. I can share the details privately if you want.
Dheeraj 351 Reputation points

2021-08-02T06:36:33.123+00:00

Any updates?
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2021-08-09T17:28:31.573+00:00

Hello @Dheeraj ,
Thanks for the patience , unfortunately we are not getting the kind of response from the team here . if you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.

Subscription ID:
Subject : Attn Himanshu
Please let me know once you have done the same.

Thanks
Himanshu
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2021-08-11T01:40:46.28+00:00

Hello @Dheeraj ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if have already reached out to the Microsoft Support , please do share the SR# , othereise request you to please do the needful as requested in the last response .
Thanks
Himanshu

1 answer

Alicja Sipowicz 1 Reputation point

2022-05-02T10:31:17.037+00:00

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?
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

1 answer

Your answer