question

DheerajAwale-4542 avatar image
0 Votes"
DheerajAwale-4542 asked AlicjaSipowicz-4555 answered

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

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.



azure-synapse-analyticsdotnet-ml-big-data
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @DheerajAwale-4542 ,
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


0 Votes 0 ·

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.

0 Votes 0 ·

Any updates?

0 Votes 0 ·

Hello @DheerajAwale-4542 ,
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

0 Votes 0 ·

Hello @DheerajAwale-4542 ,
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

0 Votes 0 ·

1 Answer

AlicjaSipowicz-4555 avatar image
0 Votes"
AlicjaSipowicz-4555 answered

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.