Dedicated sqlpool external tables query issue in a pipeline copy activity

Question

In one of our pipeline we are using copy activity to query the dedicated sqlpool external table to copy data into another storage account. However we are getting the below error:

Operation on target Copy data1 failed: Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'COPY statement input file schema discovery failed: Cannot process the file "https://ahjhkjahk.dfs.core.windows.net/container/abc/xyz/test.parquet"

because it does not exist or you don't have file access rights.',Source=,''Type=System.Data.SqlClient.SqlException,Message=COPY statement input file schema discovery failed: Cannot process the file "https://ahjhkjahk.dfs.core.windows.net/container/abc/xyz/test.parquet"

because it does not exist or you don't have file access rights.,Source=.Net SqlClient Data Provider,SqlErrorNumber=105221,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=105221,State=1,Message=COPY statement input file schema discovery failed: Cannot process the file "https://ahjhkjahk.dfs.core.windows.net/container/abc/xyz/test.parquet" because it does not exist or you don't have file access rights.,},],'