Forum Discussion
Fabric Snowflake Connector issue: SQL compilation error: Cannot unload to an inlined .
Hi v-sathmakuri smeetsh . I have found the solution for this issue. Basically in my snowflake account the flag"PREVENT_UNLOAD_To_INLINE_URL " as set true. Which mean we cannot copy the data to the external location directly due to security reasons. So we need to create a storage integration in snowflake and provide this storage integration name in the copy activity parameter of Fabric then only the copy activity will be successfull. Thank you all for your support.
we need to follow option1 mentioned in this article:
https://docs.snowflake.com/en/user-guide/data-load-azure-config
Create a separate connector of type Snowflake first. Next use that connector in the copy data activity. You should be able to read the whole table, but you could also use a simple select * from tablename if you want.
The party that supplied you with the snowflake access may force you to log in to the webportal first to change your password