Forum Discussion

NagaRK's avatar
NagaRK
Advocate I
1 year ago
Solved

Fabric Snowflake Connector issue: SQL compilation error: Cannot unload to an inlined .

Hi Team,   I am getting below error in the Data pipeline when I try to connect to Snowflake instance in Datapipeline. Could you please help? Please find the screenshot below. I see many videos thi...
Pipeline
  • NagaRK's avatar
    NagaRK
    1 year ago

    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

     

     

ares2's avatar
ares2
New Member
9 months ago

Hi NagaRK, thanks again for your response.

Yes, we had already did that, but it was still failing. The only way to solve it was removing the flag PREVENT_UNLOAD_TO_INLINE_URL. After removing this flag, everything started working correctly. It seems the issue was that Fabric uses a URL in the SQL query that points to Azure Storage, and this flag was preventing that behavior.

Hopefully this helps others facing a similar issue. Thanks again for your support!