I building a pipeline that pulls data from an Azure SQL table into Azure Blob storage in a parquet file. The data get pulled correctly but when the file has to be saved an error occurs related to the file path.
Error message:
Failure happened on 'Sink' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Upload file failed at path **<container name>/<folder>/<subfolder>/<subfolder>/<subfolder>/<subfolder>/<subfolder>/*<filename>* .,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.WindowsAzure.Storage.StorageException,Message=The remote server returned an error: (400) Bad Request.,Source=Microsoft.WindowsAzure.Storage,''Type=System.Net.WebException,Message=The remote server returned an error: (400) Bad Request.,Source=Microsoft.WindowsAzure.Storage,'
The error is caused by the "\" which should not be there and I do not have it on the file path. And it only happens on the filename
How do I resolve this?