question

AshwinMohan-0903 avatar image
0 Votes"
AshwinMohan-0903 asked AshwinMohan-0903 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
· 2
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)
AshwinMohan-0903 avatar image AshwinMohan-0903 HimanshuSinha-MSFT ·

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

0 Answers