We have a synapse pipeline that copies data from Data Lakes (Parquet Files) to the Dedicated SQL Pool in Azure. The problem is that some of the Copy Data tasks fail with a "Arithmetic overflow error converting tinyint to data type TINYINT".
We checked the Parquet file and the table in the Dedicated SQL Pool and they both have values under 256 for TINYINT columns so why is it throwing an error?