question

AshwinMohan-0903 avatar image
0 Votes"
AshwinMohan-0903 asked HimanshuSinha-MSFT commented

Could anyone help with the following error in data flow ?


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
· 3
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 @AshwinMohan-0903 ,
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 .


132477-image.png


Please do let me know how it goes .
Thanks
Himanshu






0 Votes 0 ·
image.png (21.0 KiB)

@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.



0 Votes 0 ·

Hello @AshwinMohan-0903,
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 ·

0 Answers