0

I want to query a different subscription SQL Pool using SPark can I just use the same syntax or is additional configuration neccesary and if so how to?

df = spark.read.option(Constants.SERVER, "<server>.sql.azuresynapse.net") \
    .synapsesql("<db>.<schema>.<table>")

I tried this and was getting authentication issues even though I can copy the data using Copy Activity

Thanks

Improve this question
Related questions
1
Synapse Spark Notebook Schema mismatch error while writing to a dedicated SQL Pool
0
Synapse notebook not able to read/write to dedicated sql pool or ADLS2
1
Azure Synapse Serverless SQL Pool - Error while selecting from quoted fields
Load 5 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.