Synapse is case-sensitive for column names in some scenarios. Check if the casing of the id
column in the source and target tables matches exactly.
Ensure that both the ADF lookup query and the copy activity are referring to the column with the correct casing.
If the schema name or the table structure in the target differs slightly (e.g., different schema or column definitions), this could cause the issue. Make sure the schema structure in both environments is identical.
Double-check the target schema, especially since this error mentions Schema.[Table]
. Ensure the id
column exists under the correct schema.
If you're using a parameterized pipeline, ensure that the table schema and name passed to the Copy Activity
or ForEach
loop are correct and match the actual destination schema in Synapse.
Verify that the pipeline is picking up the correct table list and columns from the lookup activity.
Sometimes a data type mismatch between the source and target tables can lead to similar errors. Ensure that the data types for the id
column are compatible between the source and target.
If you're using a distributed table in Synapse, ensure that the id
column is properly indexed and distributed across the nodes. Sometimes distributed tables can behave differently, especially if the distribution method (like hash distribution) isn't set up properly.
Let me know if you need any further guidance on a specific part!