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?

  • Are any of the values negative numbers?
    – J.D.
    Dec 29, 2022 at 14:42


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.