Forum Discussion

NagaRK's avatar
NagaRK
Icon for Advocate I rankAdvocate 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
11 months ago

Hi everyone, I'm working on the same task and despite having configured the storage integration, tested it on Snowflake side and tested all connections on Fabric side, I keep seeing the same error. Below I'm attaching the output of the "copy data" task, which keeps failing.  Can please anyone help me with this issue? Thanks in advance.

 

{
"copyDuration": 9,
"errors": [
{
"Code": 25554,
"Message": "ErrorCode=SnowflakeExportCopyCommandOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Snowflake Export Copy Command operation failed,Source=Microsoft.DataTransfer.Connectors.Snowflake,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to execute the query command during read operation.,Source=Microsoft.DataTransfer.Connectors.GenericAdoNet,''Type=Apache.Arrow.Adbc.C.CAdbcDriverImporter+ImportedAdbcException,Message=[Snowflake] 001081 (42000): SQL compilation error:\nCannot unload to an inlined external location. Please create a stage first and unload to the stage instead.,Source=Apache.Arrow.Adbc,'",
"EventType": 0,
"Category": 5,
"Data": {},
"MsgId": null,
"ExceptionType": null,
"Source": null,
"StackTrace": null,
"InnerEventInfos": []
}
],
"usedDataIntegrationUnits": 4,
"usedParallelCopies": 1,
"executionDetails": [
{
"source": {
"type": "SnowflakeV2"
},
"sink": {
"type": "AzureBlobStorage",
"region": "North Central US"
},
"status": "Failed",
"start": "10/29/2025, 11:53:55 AM",
"duration": 9,
"usedDataIntegrationUnits": 4,
"usedParallelCopies": 1,
"profile": {
"queue": {
"status": "Completed",
"duration": 5
},
"transfer": {
"status": "Completed",
"duration": 3
}
},
"detailedDurations": {
"queuingDuration": 5,
"transferDuration": 3
}
},
{
"source": {
"type": "AzureBlobStorage",
"region": "North Central US"
},
"sink": {
"type": "DataWarehouse"
},
"status": "Canceled",
"usedDataIntegrationUnits": 4,
"usedParallelCopies": 1,
"profile": {},
"detailedDurations": {}
}
],
"dataConsistencyVerification": {
"VerificationResult": "Unsupported"
}
}

 

  • NagaRK's avatar
    NagaRK
    Icon for Advocate I rankAdvocate I
    11 months ago

    Hi ares2 

    We need to follow option1 mentioned in this article. Are you able to select and set the storage integration that was created in snowflake in the Copy activity options?  

    https://docs.snowflake.com/en/user-guide/data-load-azure-config

     

    You should set the storage integration in the advanced tab as shown in the below screnshot.  Also you need to use the staging of blob storage in settings tab.

     

    Thanks,

    Rajesh.