Copying data from DataflowGen2 to Snowflake. Data Copy validates, but fails to run successfully

[jmg80525]

Trying out fabric and want to create a pipeline that moves data from DFG2 to Snowflake.  Seems like I'm close. The Copy Data assistant validates. However, when I run the process it fails with:

Failure happened on 'destination' side. ErrorCode=AzureBlobWriteOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Blob write operation on path='sfstagingblog/27b834d1-b382-4407-92e4-db2de52b6f36/SnowflakeImportCopyCommand' and blobName='3833e7f9727044009b18d677a611460f.txt.gz' failed with error message: The remote server returned an error: (405) Method Not Allowed..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.WindowsAzure.Storage.StorageException,Message=The remote server returned an error: (405) Method Not Allowed.,Source=Microsoft.WindowsAzure.Storage,StorageExtendedMessage=RequestId:dd10ea4f-301e-003e-2af7-9c3e94000000 Time:Mon, 24 Mar 2025 19:58:23 GMT,,''Type=System.Net.WebException,Message=The remote server returned an error: (405) Method Not Allowed.,Source=Microsoft.WindowsAzure.Storage,'

I'm utilizing SAS as shown below:

I enter the token here

Any insight is appreciated.

[v-prasare]

May I ask if you have resolved this issue? If so, please post your answer and mark the helpful reply accept as solution. This will be helpful for other community members who have similar problems to solve it faster.

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum  we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

[v-prasare]

Hi @jmg80525,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

@jmg80525, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @jmg80525 , As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

@lbendlin, Thanks for your promt response.

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[jmg80525]

I was under the assumption that I would have to have created the table schema on snowflake ahead of time.  I did that and checked the column mapping; all that was good.  Nevertheless, I'll try deleting the the table on SF and add those two properties to see what happens. Didn't run.  I'm pretty sure that I have to have the table already created in SF and the data copy assisant will load data into it base on the column mapping.

[lbendlin]

Don't you need "Add"  and "Create"  permissions?