Error happened when loading data into SQL Data Warehouse. Operation: 'GetTargetTableSchemaTable'

shilpa.vadgama@accenture.com 6 Reputation points
2022-09-07T07:01:45.223+00:00

I am trying to copy SQL database to SQL Dedicated Pool (Synapse) using Azure Data Factory pipeline and few copy activities are failing with below error:

`ErrorCode=PolybaseOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error happened when loading data into SQL Data Warehouse. Operation: 'GetTargetTableSchemaTable'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.,Source=.Net SqlClient Data Provider,SqlErrorNumber=-2,Class=11,ErrorCode=`  

Any pointers?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,250 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,336 questions
{count} votes