Hi,
I am trying to use Copy Data activity in Synapse Analytics pipeline and get below error, the source db (No-SQL) schema is NOT fixed, the target is SQL table which has fixed schema, there are some rows which do not contain all the fields in the mapping, I did some research and found some similar page (https://learn.microsoft.com/en-us/answers/questions/823145/data-factory-copy-data-upsert-fails-if-not-all-tar?source=docs), however it is for ADF, do you have similar solution for Azure Synapse Analytics? Thank you.
Operation on target Copy CosmosDB for MongoDB Data Flow failed: Failure happened on 'Sink' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=Column count in target table does not match column count specified in input. If BCP command, ensure format file column count matches destination table. If SSIS data import, check column mappings are consistent with target.,Source=.Net SqlClient Data Provider,SqlErrorNumber=107098,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=107098,State=1,Message=Column count in target table does not match column count specified in input. If BCP command, ensure format file column count matches destination table. If SSIS data import, check column mappings are consistent with target.,},],'