Share via

Copying data from Snowflake to Azure SQL via Azure Blob storage

Suravarapu,Sowmya,IN-Kolkata 0 Reputation points
2024-06-05T13:00:06.6466667+00:00

Copy data from Snowflake to Azure SQL DB via Azure Blob storage.

Can able to copy from Snowflake to Blob storage but while copying from blob to Azure SQL DB, getting error message as below:

Failure happened on 'Source' side. ErrorCode=AzureBlobOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Blob operation Failed. ContainerName: snowflake-amdr, path: snowflake-amdr/dev/asl/archive/staging/c9359a91-303f-47b2-877f-f6eeeab89bfe/SnowflakeExportCopyCommand/.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.WindowsAzure.Storage.StorageException,Message=Unable to connect to the remote server,Source=Microsoft.WindowsAzure.Storage,''Type=System.Net.WebException,Message=Unable to connect to the remote server,Source=System,''Type=System.Net.Sockets.SocketException,Message=A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.0.1.5:443,Source=System,'

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,199 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2024-06-05T13:00:06.6866667+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    The error message indicates that there was a failure on the source side, specifically with the Azure Blob storage. The error message suggests that there was a problem connecting to the remote server, which could be due to a network issue or a problem with the Azure Blob storage account. It is recommended to check the network connectivity and ensure that the Azure Blob storage account is properly configured with the correct permissions. Additionally, it may be helpful to review the documentation on troubleshooting the Snowflake connector in Azure Data Factory and Azure Synapse for more information on resolving issues with the Snowflake connector.

    References:

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.