This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am getting below error while trying to load dedicated SQL pool table to DF,
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Hello @Merlyn Johnson ,
Welcome to the Microsoft Q&A platform.
Could you please do share complete stack trace of the error message which your experiencing?
As per repro from my end, I am able to successfully run the query without any issues.
Hello @Merlyn Johnson ,
Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.
please find attached stack trace
Hello @Merlyn Johnson ,
Thanks for sharing the details.
We are investigating on the issue. Meanwhile, could you try to create a new Apache Spark Pool and try to run the same query and share your findings?
Thanks Pradeep, I tried with new Spark Pool and got attached error.124340-error.txt
Hello @Merlyn Johnson ,
Regarding the above error message, try to add Synapse Spark Administrator permission from Synapse studio to be able to perform read execution for Spark pool tables.
still getting same error
Hello Readers,
Regarding this issue, we are working offline with the internal team. We will update our findings once the issue is resolved.
this has been resolved after creating user in the dedicated sql pool.
Hello @Merlyn Johnson ,
Glad to know that your issue has resolved. You can accept it as answer. This can be beneficial to other community members. Thank you.
Hello @Merlyn Johnson ,
Did you get a chance to click on (
) button? This can be beneficial to other community members. Thank you.