Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Could anyone help with the following error in data flow ?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 57.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Ashwin Mohan
11
Reputation points
Data flow source is snowflake source [onprem]
While running the query [even for a select query ] , it's giving the following:
Dataset has reader role present.
net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:
Stage 'ABC_WH.SUPPLY_CHAIN_ANALYTICS.SPARK_CONNECTOR_UNLOAD_STAGE_N1Y85OTN4Z' does not exist or not authorized.
I have tried giving the full dbname.schemaname.tb..syntax .
Azure Data Factory
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator2021-09-15T19:03:25.68+00:00 Hello @Ashwin Mohan ,
Thanks for the ask and using Microsoft Q&A platform .Can you please check if the linked service is setup correctly and if the test connection is successful ?
From the syntax side , When i checked I was able to query with SELECT * from sometabe; " works fine .
Please do let me know how it goes .
Thanks
Himanshu -
Ashwin Mohan 11 Reputation points
2021-09-16T06:08:43.757+00:00 @HimanshuSinha ,
The connection works fine. Actually the data preview comes in copy data activity.
I am trying to preview in a data flow and it's giving in unload stage error . [I require data flow for some additional operations].I have also tried to preview by selecting table from the drop down. It still gives unload stage error.
-
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator
2021-09-23T20:52:46.487+00:00 Hello @Ashwin Mohan ,
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
Sign in to comment
Sign in to answer