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]

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-prasare]

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

[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?