Could anyone help with the following error in data flow ?

Ashwin Mohan 11

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 .

HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-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-msft ,
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-msft 19,376 Reputation points Microsoft Employee

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